Report question?

H

hmm1979

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
 
A

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top