Breaking Report into Minute Detail

[johnsonlg]

I'm working on breaking a report down by subgrouping A, then B, then C
however, subgroup C has even a finer detail which needs to be grouped
by hours - H, then by Salary - S and lastly by Dollar amounts - D. I
can get it broke down to the H level but even with multiple IIF
statements I can't group the data according to the user's
requirements. I was thinking that I could use multiple queries to
separate this data out, but am unsure how to use multipe queries
within the report without using sub reports. I am a novice to VBA and
am trying to accomplish this with the functionality of ACCESS. If
this can be done can someone point me in the right direction.

Thanks in advance!