If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
linking queries to create a report
is it possible to link queries to create a report?
if so how would i do this? |
#2
|
|||
|
|||
linking queries to create a report
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 "Susan" wrote in message ... is it possible to link queries to create a report? if so how would i do this? |
#3
|
|||
|
|||
linking queries to create a report
"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 |
Thread Tools | |
Display Modes | |
|
|