General discussion



By chipsythegypsy ·
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!

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Comments

Collapse -

by JRod86 In reply to Invoices

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.

Related Discussions

Related Forums