Reports

  • Thread starter Thread starter Dave Dennis
  • Start date Start date
D

Dave Dennis

What is the "best" way to create a report (similar to a
mail merge) where data fields are added to "boilerplate
text?"

I need to create several reports using data from more than
one table per report.

Thanks in advance for any help.

Dave
 
Dave,

Something like ="your standard unchanging text "&
[fieldname1]&" more standard text "&[fieldname2] in an
unbound control will provide something like a merge field
in a word document. If you require lots of formating such
as bold, italic underline, fonts and different sizes I
would suggest looking at using word mailmerge with access
as your data source.

If you need to include address blocks in
your "boilerplate" the following is one that I often use:

=[Title]+" " & [first name]+" " & [last name] & (Chr(13)
+Chr(10)+[address line 1]) & (Chr(13)+Chr(10)+[address
line 2]) & (Chr(13)+Chr(10)+[address line 3]) & (Chr(13)
+Chr(10)+[locality]+" "+[state]+" "+[postcode])

The use of "+" allows any white space to be filled by the
line below. (If there is no address line 2 or address line
3 there won't be blank lines. Substitute your field names.

HTH,

Terry
 
Back
Top