Construct a query from columns of several other queries

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
(e-mail address removed)
 
Steve said:
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

--
Get lost Steve!! We don't need you here !!, but....
==>Let's ask it the 'nice' way...
Would you please, please go away Steve ??

This is to inform 'newbees' here about PCD' Steve:
http://home.tiscali.nl/arracom/whoissteve.html (updated, mainly the 'abuse-reporting' page...)
Until now 3800+ pageloads, 2400+ first-time visitors
(these figures are real and rapidly increasing)

Why is this ???
Because Steve is the ONLY person here who continues to advertise in the groups.

It is not relevant whether he advertised in *this* particular post or not...
==> We want him to know that these groups are *not* his private hunting grounds!

For those who don't like too see all these messages:
==> Simply killfile 'StopThisAdvertising'.
Newbees will still see this warning-message.

ArnoR
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top