I
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.
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.