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!

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

Multiple Queries 1 Report

Status
Not open for further replies.

ksimmsa

Programmer
Feb 6, 2004
22
US
I have 2 separate queries that I need to combine to create one report. What steps to I need to take to create the report?


Thanks in advance for you help.

 
Query 1

SELECT DISTINCTROW Sum([qryCallbackComplet Query].Closed) AS [Count]
FROM [qryCallbackComplet Query];


Query 2

SELECT Count(*) AS [Count]
FROM qryDateRange
GROUP BY qryDateRange.[Follow Up Date]
HAVING (((qryDateRange.[Follow Up Date]) Is Null))
ORDER BY Count(*);

 
Try create a union query from the two queries:
Select * from [Query 1]
UNION ALL
SELECT * from [Query 2];

or try just one query:

SELECT Sum(Closed) AS [Count]
FROM [qryCallbackComplet Query]
UNION
SELECT Count(*)
FROM qryDateRange
GROUP BY qryDateRange.[Follow Up Date]
HAVING (((qryDateRange.[Follow Up Date]) Is Null))
ORDER BY Count(*);


Duane
MS Access MVP
[green]Ask a great question, get a great answer.[/green]
[red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]
[blue]Ask me about my grandson, get a grand answer.[/blue]
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top