J
Jenny B.
Hi All,
I’m a bit green to the Access Report usage, so please bear with me in the
event you’ve answered this question multiple times (didn’t see an entry quite
like this).
I have a Report I’m constructing that pulls fields from the preformatted
Entry Form. In addition to the data fields, I also want to add a large block
of static text that will always be the same minus the merge fields (see the
example below). I’ve been able to do this successfully without linking to a
table, but I’m only allowed a certain number of characters. Since I’m not
linking to a table, I’m stuck and don’t know how to change it over to a Memo
(seems to make me select text without a link).
Any thoughts on how I can achieve the below, but create a much longer letter?
Thanks – Jenny B.
="In reference to your visit on " & Format([DateLastVisit],"mm/dd/yy") & "
with " & [Physician] & ", your " & [TestType] " & came back with " &
[TestResult] & ". We have scheduled a followup visit on " &
Format([DateNextVisit],"mm/dd/yy") & "."
I’m a bit green to the Access Report usage, so please bear with me in the
event you’ve answered this question multiple times (didn’t see an entry quite
like this).
I have a Report I’m constructing that pulls fields from the preformatted
Entry Form. In addition to the data fields, I also want to add a large block
of static text that will always be the same minus the merge fields (see the
example below). I’ve been able to do this successfully without linking to a
table, but I’m only allowed a certain number of characters. Since I’m not
linking to a table, I’m stuck and don’t know how to change it over to a Memo
(seems to make me select text without a link).
Any thoughts on how I can achieve the below, but create a much longer letter?
Thanks – Jenny B.
="In reference to your visit on " & Format([DateLastVisit],"mm/dd/yy") & "
with " & [Physician] & ", your " & [TestType] " & came back with " &
[TestResult] & ". We have scheduled a followup visit on " &
Format([DateNextVisit],"mm/dd/yy") & "."