Combine two queries

[Shannon88]

I have two seperate queries performing a different task in each but each query has the identicial field names. The calculations are correct and I want to print them in a report. Since they are in seperate queries I can't get them together. When I combine them it gets all messed up. If this is not possible, then how to I tell a query to perform a calculation when another field says "Free Goods". When and Pay Type is "Free Goods" I want the grand total * .25 Else Free Goods = 0. I guess I am confused on where I should doing this calculation and how to do it. I have tried directly on the report, in the query and I even tried to put it on my print button. I keep running into problems. This is my first time using Project and I am not really good at writing code. Any help would be much appreciative.

Thanks,

Shannon

 

[DerekAOE]

If you want to combine two queries into a single result set you might consider creating a new query that uses 'UNION'.
Both queries MUST return the same columns for this to work.

Note that UNION queries will not display in the graphical query desing window, you'll have to define it in SQL view only.

 

[mp9]

A useful summary of UNION queries and their syntax can be found at

http://www22.brinkster.com/accessory/queries/002.shtml

 

[cmmrfrds]

It is easier to give advice if you include an example of the query results that you want to see. Maybe even the query if it is not too large.

 

[Shannon88]

Thank you everyone for helping me, the union query is exactly what I needed.