creating report

[Guest]

I have downloaded the Personal address book database from the Office
templates. I want a report were I can create a Christmas mailing list were
the listings appear as (i.e.) Mr. and Mrs. John Smith and Family, followed by
there address. I am a rookie user to Access, so if this is possible without
a lot of programming, that would be great.

 

[Guest]

Just use the report wizard to start building the report the way you want.
Delete the first name field and in the last name field use the following:

="Mr. and Mrs. " & [first name] & " " & [last name] & "and family"

The result will be:

Mr. and Mrs. John Smith and family