Group By-How do I trap the rolled up fields

Giganews Newsgroups
Subject: Group By-How do I trap the rolled up fields
Posted by:  nhir…@hotmail.com
Date: 7 Aug 2006

I have 4 fields in my table Field1, Field2, Field3 and Amount. A unique
record in this table is defined by the combination of Field1, Field2
and Field3. I have a query that rolls up by Field1. The other 2 fields
- Field2 and Field3 are not used in the aggregate query - hence are
rolled up. The Amount field is Summed up to display the total.

Question - I want to know what makes up the aggregate record. How do I
find out what records (Field2 and Field3) make up the aggregate record.

Any thoughts are appreciated.

Replies