|Subject:||Group By-How do I trap the rolled up fields|
|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.