Prev: Calculate beginning balance, but print details on report
Next: Auto-generated Report
From: Susan on 22 May 2010 08:52
is it possible to link queries to create a report?
if so how would i do this?
From: Steve on 22 May 2010 10:53
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
santus(a)penn.com


"Susan" <Susan(a)discussions.microsoft.com> wrote in message
news:4D55A52C-0DE2-462A-9B1A-95C3C4114A8C(a)microsoft.com...
> is it possible to link queries to create a report?
> if so how would i do this?


From: Larry Linson on 22 May 2010 14:45
"Susan" wrote

> is it possible to link queries to create a report?
> if so how would i do this?

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.

--
Larry Linson, Microsoft Office Access MVP
Co-author: "Microsoft Access Small Business Solutions", published by Wiley
Access newsgroup support is alive and well in USENET
comp.databases.ms-access


 | 
Pages: 1
Prev: Calculate beginning balance, but print details on report
Next: Auto-generated Report