Summary Report

[BB]

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, BB

 

[Pat Hartman]

Create separate queries to summarize the data from the individual tables. Then create a "master" query that joins all the other queries. You will need to select the Account table first so that you are sure to get all the accounts and then create separate left joins from the Account table to each of the summary queries. So (I can't do a graphic representation so use your imagination) the top part of the QBE grid will look something like:

Account ---> QryCreditCardStatement
Account ---> QryRental
Account ---> QryOutsideRental
Account ---> ....