SELECT DISTINCT RECORDS FROM A TABLE

Hanen

Hi,
How can I retrieve distinct records from table and grouping them for exemple :

Item 1 - 2 slides
Item 1 - 5 slides
Item 2 - 4 slides
Item 3 - 1 slide
Item 1 - 3 slides
Item 3 - 3 slides

Result :
Item 1 - 10 Slides
Item 2 - 4 Slides
Item 3 - 4 Slides

Thnx for help !

kriki

Take a look at this: http://www.mibuso.com/howtoinfo.asp?FileID=22.
The last point (Make a total amount per "Gen. Bus. Posting Group" and "Gen. Prod. Posting Group" of table 15:"G/L Entry".) is also usable to make a temptable with unique values.
Then you can read the temptable to have your distinct record.

Hanen

Thanks for the answer :thumbsup: