Creating an Invoice

[jimd1768]

I would like to create an invoice for the orders in a database. I have tried but failed miserably to get a report that shows all items on the order form. I have attached the sheet I am getting info from to try to get the invoice.

The details I am want are:

Customers: Customer ID, Name, Address, email, Shipping Method
Order: Order ID, PO Number
Products: Product, quantity, unit price, total price

Order Subtotal
Shipping cost
Total.

If anyone could guide me to creating an invoice per customer order, I would be eternally grateful.

 

[PNGBill]

You have an Orders Form and now want an Orders report that replicates the Orders Form??

If so, close your OrdersForm and then Right click on the Name in your Forms.
Save As Report.

This will give you a report that looks just like your Form. Even has the Colouring.

Just do a little Housekeeping eg, Command Buttons show but of course no longer work, or need to work.