I had set up a database in Access 2000. I set it up with relational tables, 1 for the job information and 1 for the clients in the job, the job # is the link to the tables. I made a form that combined the information in the 2 tables with a query to perform math calculations and get payment totals. THEN I had several different Mail Merge letters set up in Word that were tied to the Access query and I could extract client information for each job and pick the clients from each job. I would basically enter the information in the Access form, the query totaled the math which I could see in the form, the go to Word and select the job and client from the Access query (which is linked to the 2 tables)and print reports in Word.
THE PROBLEM IS with Office 2003, I have information in both tables that I need printed on the letters and I have math calculations in query (that is why I linked from query) and Mail Merge in 2003 only lets me link to 1 table only with no option for query. What do I do now??
THE PROBLEM IS with Office 2003, I have information in both tables that I need printed on the letters and I have math calculations in query (that is why I linked from query) and Mail Merge in 2003 only lets me link to 1 table only with no option for query. What do I do now??