A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Setting Up & Running Reports
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

linking queries to create a report



 
 
Thread Tools Display Modes
  #1  
Old May 22nd, 2010, 01:52 PM posted to microsoft.public.access.reports
Susan
external usenet poster
 
Posts: 651
Default linking queries to create a report

is it possible to link queries to create a report?
if so how would i do this?
Ads
  #2  
Old May 22nd, 2010, 03:53 PM posted to microsoft.public.access.reports
Steve[_77_]
external usenet poster
 
Posts: 1,017
Default 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  
Old May 22nd, 2010, 07:45 PM posted to microsoft.public.access.reports
Larry Linson
external usenet poster
 
Posts: 3,112
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 01:31 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
Copyright 2004-2018 OfficeFrustration.
The comments are property of their posters.