linking queries to create a report

  • Thread starter Thread starter Susan
  • Start date Start date
Yes. The queries need a common field (for example CustomerID) which you can
link between the queries. Open a new query in design view. Add the queries
you want to link to the query window. Link between the common field by
dragging the field from one query to the other. Finally pull down the fields
ypu want from each query.

Steve
(e-mail address removed)
 
is it possible to link queries to create a report?
if so how would i do this?
Click to expand...

What do you mean by "link queries"?

If you have multiple queries with additional information about the same
subject (a customer, say), that is, in Access parlance "join"ing those
queries. That is what Steve's answer addresses.

If, on the other hand, you have multiple queries with the same information
about different subjects (many customers, say), then you need to "UNION"
those queries... all the queries in a UNION must have consistent format for
the data in the same column. Check HELP for UNION and UNION ALL. Sad to say,
this feature is only avaiable in SQL view of the Query buider; no visual
option. But, happy to say, it is really quite simple SQL -- you can copy and
paste most or all of it, and just add the UNION or UNION ALL commands.
 
Back
Top