Making a report that sums specific bale types

[Zetheroth]

Hello everyone, I have come (again, second time today) to ask for the help of those more skilled than me. I intent to create a report based off the attached database, and int the report I need to be able to sum data from multiple queries. I need to sum the total amount of hay purchased for each bale type combination, and I need to sum the total bales picked up for each combination, but only display the ones relevant to the chosen buyer (see report maker on main menu). I also need it to subtract the bales picked up from the ones purchased, to show what inventory we still owe them. Lastly, I need to put the total still owed from the sales report onto the report, and take it off the sales report.



I look forward to you mad lads helping with my problem as I have no idea where to begine.Sales Examples .9.zip

[ranman256]

make a UNION query that collects from all different queries:
qnUnion:
select * from qsQry1
union
select * from qsQry2
union
select * from qsQry3


then make the final query to sum your fields from qnUnion

NOTE: all queries in union must have the exact same fields in same order.