Filtering same items in invoice

[ILIR ISTREFI]

Hello, I have difficulty with some invoices so it seemed to me logicaly
possible to resalve this problem in Access.

I receive quite often long invoices with articles getting repeated, becase
of time interval when the goods were ordered. So i managed do export
invoices from PDF -format to TXT files and after few adjustments I did
manage to Convert it to Exel format and then invoice is accessible from
Access.
Now all items have ther serial numbers and data look's like this:

No. Serial. Name. QTY. Price Sum.
1 123456 Blanket 3 2 6
2 132321 Pillow 1 3 3
3 123456 Blanket 4 2 8.

What i need to do now is filter product in whay that item 1 and 3 in the
above example to be displayed as a sinle item with calculated values of QTY,
Price and Sum in the above example.
Is there any chance to do that ?
This would seve me a lot of time.

 

[Allen Browne]

Create a query to use as the source for the report.

In query desgn view, depress the Totals button on toolbar (upper sigma
icon).
Access adds a Total row to the grid.
Accept Group By under Serial and Price.

Choose Sum under Qty.

Choose Expression under your calculated field, which will now be:
SumOfQty * Price