Hello!
I have a query which returns something like:
Code | Quantity
-------------------------
aaa 2
bbb 3
aaa 4
How to select records to look like this:
Code | Quantity
-------------------------
aaa 6 <=== which is the cumulated quantity
bbb 3 of the records with the same
Code: "aaa"
Many thanks in advance!
I have a query which returns something like:
Code | Quantity
-------------------------
aaa 2
bbb 3
aaa 4
How to select records to look like this:
Code | Quantity
-------------------------
aaa 6 <=== which is the cumulated quantity
bbb 3 of the records with the same
Code: "aaa"
Many thanks in advance!