Construct a query from columns of several other queries

P

Pat

I have 5 queries from which I'd like to create a new query. I want to
extract columns from each of the 5 queries to make the new one. They would
all be 'joined' on the same common field. I think I can do this by doing 4
successive joins, starting with queries 1 and 2, then queries 1/2 and 3, then
1/2/3 and 4 etc., but Is there a way to do this in one step?

Thanks
 
S

Steve

Yes, create a new query and include all five queries. You can join all the
queries in the query window just by clicking and dragging.

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
[email protected]
 
Top