Report question?

[Guest]

I am working in Access 2007 and I need to run a report that generates a
customer invoice for each order (InvoiceID) placed. The invoice should print
one invoice ID per invoice (page(s)). Also I have to make calculations to
provide each customer a total amount for each invoice.

Here's what I am thinking?? Do I need to run a query before creating the
report? And I know to create the calculation that I have to use the
expression builder to multiply the quantity by the price....

I have 4 tables that I need to use: tblCustomer, tblInventory,
tblCustomerInvoice, and tblInvoiceItems.

Fields for tblCustomer: Customer ID(primary), CName, CAddress, CCity,
CState, CZip, CContactFirstName, CContactLastName, CTelephone, CFax.

Fields for tblCustomerInvoice: InvoiceID(primary), CustomerID,DateofInvoice.

Fields for tblInvoiceItems: InvoiceID, ItemID, Quantity

Fields for tblInventory: ItemID(primary),ItemName,Price,QuantityOnHand.

Any suggestions would be greatly appreciated!!!

Marie

 

[Allen Browne]

The Northwind sample database that installs with Access has an Invoice
report that shows how to do this.

Essentially, it is a report with a Group Header for each invoice (so each
one starts on a new page), and a Group Footer that shows the invoice total
(sum of extended amount) below the line items.