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!
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!