By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
431,745 Members | 1,957 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 431,745 IT Pros & Developers. It's quick & easy.

Group By-How do I trap the rolled up fields

P: n/a
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.

Aug 7 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a
nh****@hotmail.com wrote in
news:11*********************@p79g2000cwp.googlegro ups.com:
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.
You create a second query, which calls the first query joined to
the table on field1...

Or you create a form on the query, with a subform on the table,
joined on field1...,

Or you can substitute report and subreport in the above option.

--
Bob Quintal

PA is y I've altered my email address.

--
Posted via a free Usenet account from http://www.teranews.com

Aug 8 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.