I'm trying to divide a table into four categories based on three fields and put the totals for each field all on a single report. This is easy to do using four queries, but I can't figure out how to tie them all together in a report.
If it helps,
The first category is comprised of specific items (e.g. between 0001 and 0004 and between 0089 and 0100)
The other three categories do not have those specific items, but are divided based on two check boxes.
How should I approach this?