Go to the database window, click on Queries and click on New. You'll see you can
create an unmatched query. Use that option to create a new query and find all
the records in your biz base query that do not match any records in your base
home address query. Then build a new union query combining the new query with
the base home address query. Your new union query will not now have any
duplicate records.
--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdatasheet.com www.pcdatasheet.com
"M Stery" <ms****@soon.com> wrote in message
news:8b*************************@posting.google.co m...
Have two base queries used for mailing labels with
id,name,address,city,state,zip that are combined via a union query.
One base query uses home address; the other base query uses biz
address. I only want one label per person. In a few cases, I have a
record with both a home address and a biz address, which I don't want
in the labels. How or can I make the union query omit an id in the biz
address base query IF that same id has a record in the base home
address query? I'm drawing a blank on this one. Thanks for any
advice.