Hello all,

I'm working producing a set of mailing labels. Access is used to edit/hold the data and Word will be used to do the label merge with the DB as the data source. Here's my problem: I'm having trouble getting the correct data into the merge.

There is a main table with all the relevant address data, but for some reason, the DB was set up with look up fields for the City, State, ZIP, and CompanyName. When I run a simple query to get the info for the labels, the data looks fine in the query window, but when I export or use the query as a data source, I end up with the ID# from each of the smaller tables instead of the City, State, etc...(These tables have an auto-number as the primary key with a description field).

Can someone give me a hand here? I've read through several manuals, but they're not very much help. I appreciate any help I can get. Thank you. -RK

__________________
She stood on the bridge at midnight,
Her lips were all aquiver.
She gave a cough,
Her leg fell off,
and floated down the river.

I guess I'm wondering why you don't use Access for printing the labels.

Beth M

*Blush* Thank you for not laughing, or at least, not lauging where I could hear you. :-) This certainly is a Monday. Thank you.

-RK

No problem. Sometimes the easiest is the all-too-obvious and we overlook it. Kind of like, "I couldn't see the forest for all of the trees"