invoices with mutliple items

[wezel99]

Hi, I am importing data from a supplier.

The table has many invoices included and varying items on each invoice. I need to find a way to separate each invoice with all the included items. For example:

inv# pieces linedesc amount
11 500 nuts $20
11 100 bolts $15
11 75 washers $10
12 150 cameras $75
13 10 desks $150
13 10 lamps $50

Thanks in advance for the assistance.

 

[plog]

For example:

Is that example starting data or the ending data you want? You need to provide us with both. So post again, this time showing us 2 sets of data--starting and what you want.

 

[wezel99]

Thanks for the speedy reply.

They could search an inv.# and it would bring back all line items for said invoice. Ending data would be more like this:

search inv. 11 result
inv# pieces linedesc amount
11 500 nuts $20
11 100 bolts $15
11 75 washers $10
________________________________
search invoice 12 result
12 150 cameras $75
_______________________________
search inv 13 result
13 10 desks $150
13 10 lamps $50

 

[plog]

That is more of a report issue than a query issue. Here's a tutorial from Microsoft for reports:
http://office.microsoft.com/en-us/access-help/create-reports-for-a-new-database-RZ101773004.aspx

The key is to add an Invoice Grouping to the report along with a header. You could even put a total field at the bottom and count how many items each invoice has. Check out that tutorial and it should walk you through exactly what you want to do.

 

[wezel99]

Much appreciated, apologize for the wrong section. I'll take a look and see if this does the trick!