How To Include Multiple Queries Into One Report

[newuserthatneedsassistanc]

How would I do a union query between Query 1 and Query 2 and put that into one report?

[RuralGuy]

This link may help: http://www.fmsinc.com/MicrosoftAcces...#Union_Queries

[newuserthatneedsassistanc]

For some reason it says that the columns have to be the same amount or something in order for the UNION ALL statement to work (smh). These are no where close to being the same column amounts.




Im trying to get all the projects with a status of a-h to show up in a report






and in that same report, I need to be able to see the projects that has a transtype L


These are two separate queries

[newuserthatneedsassistanc]

104 records from Query 1 + 32 records from Query 2 so in that report there should be 136 records (32 of them being L)

[RuralGuy]

As the link I posted stated, the two queries must have identical fields.

[orange]

You want UNION not UNION ALL which includes duplicates/replicates (unless you want the duplicates)

[newuserthatneedsassistanc]

How would I subtract a report column against a sub-report column?

[newuserthatneedsassistanc]

How come when I write this equation it outputs redundancy?

All I'm trying to do is to figure out the difference between the two columns.
If I delete the expression there is no redundancy