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!

How do I combine results of multiple Queries into one Report?

Status
Not open for further replies.

spow

Technical User
Jun 11, 2002
8
US
I have a few queries that output some data as shown:

query1:
---------
[newproject_name, NewProject cost]
proj1 10
proj2 11
query2:
---------
[continuing_project_name, ContinuingProject_cost]
proj3 8
proj4 6
How would I combine these 2 queries into one report to show:

Report:
--------
Project Name NewProject Cost ContinuingProject Cost
proj1 10
proj2 11
proj3 8
proj4 6


thanks for any help!
 
Use this as the Row Source for your report. Lookup Union Operation in Help if you have any questions about aliases, where, group by or order by clauses. Good Luck.

SELECT newproject_name as name, newproject_cost, null as continuingproject_cost
FROM newproject

UNION ALL

SELECT continuingproject_name, null, continuingproject_cost
FROM continuingproject;

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top