query looks good - mail merge -wrong field showing

[taylornow]

Hello everybody,- hard question to explain but here goes. Database for a conference. Different tables for each workshop section. Different classes (some duplicate-different times) for each section. Set up with class title as combo box for ease in entering. Example of one of the tables:

Workshops1
Field Name Data Type
ID5 Number (this is primary key)
ClassName Text
Description Text

I run the query for all the tables combined and it looks great but when I run the mail merge off the query, the field that shows is the Primary key or rather "ID5". I need the ClassName field to show on the document. There will be duplicate ID numbers because the other tables are set up the same way - just different class names. I need to send confirmation letters and no names show up - just the ID numbers. Am I totally screwed??? Thanks in advance.

 

[hermanlaksko]

Try doing this:

Turn your query into a createtable query (first time then into an appendquery) dump all your data into this table.
Now merge with this table - now you know exactly what you have in your "mergequery" and can thereby see/eliminate any errors.
At the beginning of each session you must, ofcourse, delete * from your merge table.

 

[taylornow]

Thanks - I will give it a go this a.m..

Taylor