QUERIES - USING 3 EXISTING TO MAKE 1 COMBINED

I HAVE 3 QUERIES FROM 3 TABLES THAT I NEED TO MERGE ALL THAT INFO INTO 1 CAN THIS BE DONE W/BEING A PROGRAMMER?

"TXTEAMSTER" wrote in message

I HAVE 3 QUERIES FROM 3 TABLES THAT I NEED TO MERGE ALL THAT INFO
INTO 1 CAN THIS BE DONE W/BEING A PROGRAMMER?

Probably yes, but you'd have to explain more about what you want. Is it
that you have three queries that return equivalent sets of fields, and
want to get all the records returned by all three queries into one big
set of records? Or are these queries that return sets of related data,
so that you join the query results together on a record by record basis,
ending up with one record with some fields from query 1, some fields
from query 2, and some fields from query 3?

It might be clearer if you posted the SQL of each of the three queries.

P.s. Please don't type all in capital letters. It feels like you're
shouting at us.

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)