Software

Ask something
Discussion Locked

Invoices

0 helpful
1 reply

by chipsythegypsy

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I am working on a system which has two tables; one for names and addresses and one for multiple orders linked by customer and part number. I need to create an invoice which can be in either access or word showing multiple entries and total value for customers who've ordered multiple items. Help!

1 reply

by jrod86

Sounds to me like you need to build a query. In Access this is pretty easy. Open a new query in a Wizard and you can make all the selections of information you want displayed.

Or you can open one in design view and add both tables. You can add the customer name, address, part number, cost, then total the cost in another field.

You would have to be much more specific about the fields in the tables and exactly what you want to see in the query to get a more accurate response.

This discussion is closed to new replies.