Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Using 2 queries

Status
Not open for further replies.
coryras

coryras

Programmer
May 8, 2003
9
US
How can I use 2 Different Queries in the control source of a report. I want to use to separate queries.
 
Sort by date Sort by votes
Go to report properties, data tab. Under "record source" you can build a query by typing in SQL or using query builder (click the little button with the 3 dots ... on recordsource).
 
Upvote 0 Downvote
Yeah how can I use 2 different queries in the record source?
 
Upvote 0 Downvote
If the queries already exist just use query builderto select and join them.

If your question is really how to combine the results of two separate queries on the same report, then this is a different matter. You can create a separate report based on each query then create a third report and include reports 1 and 2 as subreports on the third report.

 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

VicM
  • Locked
  • Question
Curious behavior using Chr(10) & Chr(13)
Replies
4
Views
886
SoftwareRT
SoftwareRT
soloracer
  • Locked
  • Question
Problem using report recordsource values within report events. Error 2427 1
Replies
17
Views
531
soloracer
soloracer
GPnew
  • Locked
  • Question
Access 2016 report export to excel column order changes
Replies
2
Views
249
GPnew
GPnew
lameid
  • Locked
  • Question
#Type! using replace on Long text field
Replies
4
Views
461
lameid
lameid
DataPaper
  • Locked
  • Question
Int to Bin 2021
Replies
2
Views
210
SkipVought
S

Part and Inventory Search

Sponsor

Back
Top