Word XP mail merge to Access XP query ...

W

WVU-CEMR-ADM

Having problem merging Access XP query into Word XP letter

Setup:
Created DB1.MDB
Table1 contains Name, Part1, Part2
Query1 References Table1
- Name, Part1, Part2 are to be displayed
Create MERGE1.DOC
Mail merge with DB1.MDB,Query1
.... works fine
.... note Table1, Query1 listed as possible data sources

Query2 References Table1
- Name is to be displayed
- iif(Len(Part1)>0,Part1 & Part2,Part2) displayed as fullpart
.... Query2 in Access looks correct
Create MERGE2.DOC
Mail merge with DB1.MDB,Query2
.... note Table1, Query1 listed as possible data sources
.... where is Query2???
.... go back to DB1.MDB and remove iif syntax and now Query2 appears in the
list

Goal:
Using Access to build a sentence with a query when under the following
conditions.
<<Name>> is <<FullPart>>
The query is then referenced in the Word merge.

Any ideas?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help creating a search form in Access XP 0
Query keeps looking for Query1 field 3
Make query headings just contain field names? 1
Mail Merge query 1
Integrating information from Word to Excel (not mail merge) 1
Mail Merge - displaying a conditional number of decimals 5
Sumproductlike in Access 1
Crosstab Query In VBA 3

Top