newbie question on grouping

[flaviooooo]

I have a report like this

date article m² kg
6/2 4 15 10
7/2 4 20 20
7/2 4 15 10
7/2 5 10 11
7/2 5 12 15

Now i'd like to have it like this:
date article m² kg
6/2 4 15 10
7/2 4 35 30
7/2 5 22 26

So i need to group on date, then article... but how can i get the totals of the other fields?? please help

 

[JeremyNYC]

Check into the help files for this one. Basically you'll want to click on the totals button on the top of the query and choose group by for the first two fields and Sum for the second two fields.

Jeremy ==
Jeremy Wallace
AlphaBet City Dataworks

http://www.ABCDataworks.com

Affordable Development, Professionally Done

Please post in the appropriate forum with a descriptive subject; code and SQL, if referenced; and expected results. See thread181-473997 for more pointers.