Multiple Queries 1 Report

[ksimmsa]

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.

 

[lespaul]

what is the SQL for the two queries?

 

[ksimmsa]

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(*);

 

[dhookom]

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]