Summary Report

[brbarto]

I need to create a report that simply has account names (and numbers) and the total amount charged for the month. Some accounts won't have any charges. (I have an account table.) The major problem is the charges must be calculated from many tables (such as CreditCardStatement, Rental, OutsideRental, InventoryParts, NonInventoryParts, Labor, Adjustment, etc.). Is this enough info that someone can at least point me in the right direction. Although any detail you can give me would be greatly appreciated as I am new to Access.

Thanks

 

[ToeShot]

I will assume that you have these tables related to a main table for um lets say customer. If this is true then you would create a query and add all the tables that have the pertinent information in it. then select all the needed fields. Here you may need to right click in the query design view and go to query type and select CrossTab. then repeat this process and sselect Select Query. this will give you a grouping row were you can select Sum this will sum all the follows for each customer.

HTH