Word Mailmerge

[Guest]

Hello all,

I have created a Lease Management Database. One of the tables in the
database will manage "tasks" completed. The main fields are:


Task1
Task1 Complete (Y/N)

(there will be 6 - 10 tasks per location).

I would like to create a Report or Word merge document that will show those
tasks which have been checked completed to show up in one section of the
report, and those that haven't been completed to show up in another section.

Can someone help me with this?

Thanks.

 

[David PONDA]

U talk about merge the two table togetter, so try to merge to querry.
1. create the first query and save it qry1 and link it to ur first table
task1
2. create the second one and save it qry2 and link it to the 2nd table
3. now launch the report wizard and in linkable session link and call both
table, bye using the one in header session and the secon in detailled
session.