Multiple detail areas in one report

[Tom Brown]

We are creating a database which uses several forms to input data into a
Master_Data table.
There are several categories for the data ex: Full Service Driver, Trade
Driver, Misc Receipts, Misc Payouts.

I need a report that breaks these categories out in detail like so:

Cashier Driver# Driver Name Full Service Checks Full
Service Currency Full Service Coin



Subtotal

Cashier Driver# Driver Name Trade Checks Trade Currency
Trade Coin



Subtotal

Cashier Driver# Driver Name Misc Receipts Checks Misc
Receipts Currency Misc Receipts Coin



Subtotal

Cashier Driver# Driver Name Misc Payouts Checks Misc
Payouts Currency Misc Payouts Coin



Subtotal

Is this possible? I tried using a query to pull all the categories in the
Master_Data table and then made a report out of that. It pulls the data and
gives me subtotals and detail but is very big and very clumsy. Any help?

Thanks,

Tom

 

[Marshall Barton]

We are creating a database which uses several forms to input data into a
Master_Data table.
There are several categories for the data ex: Full Service Driver, Trade
Driver, Misc Receipts, Misc Payouts.

I need a report that breaks these categories out in detail like so:

Cashier Driver# Driver Name Full Service Checks Full
Service Currency Full Service Coin



Subtotal

Cashier Driver# Driver Name Trade Checks Trade Currency
Trade Coin



Subtotal

Cashier Driver# Driver Name Misc Receipts Checks Misc
Receipts Currency Misc Receipts Coin



Subtotal

Cashier Driver# Driver Name Misc Payouts Checks Misc
Payouts Currency Misc Payouts Coin



Subtotal

Is this possible? I tried using a query to pull all the categories in the
Master_Data table and then made a report out of that. It pulls the data and
gives me subtotals and detail but is very big and very clumsy. Any help?

Beyond your dislike, I don't know what "big and clumsey"
means.

If your report uses Sorting and Grouping (view menu) to
group on the category field, the report should be organized
pretty much the way you want.

Other than that, you should explain what the records for the
report look like along with how the fields are used in which
report section.