If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Multiple detail areas in one report
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 |
#2
|
|||
|
|||
Multiple detail areas in one report
Tom Brown wrote:
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. -- Marsh MVP [MS Access] |
Thread Tools | |
Display Modes | |
|
|