sum and max in the same query

[slimjen]

All, using access 2010. I am trying to keep from creating multiple queries for one solution. Have two table joined by custid. query: custid and state from one tbl and grossreceipts and costid from the other table. group by custid, state and costid and sum gross receipts. Then I need to get the max of sum gross receipts, group by custid, state and costid and add the results to another table. Do you see a way to get this down to possibly one query?

[June7]

Could possibly nest the queries but no, don't think one SELECT will suffice.

Are you trying to save aggregate data to table? Why?

[slimjen]

No. Append custid, state and costid; not receipt. Using max receipts or refererce for other data. Im open to nesting if it eliminates multiple tables. I tried using another select to get the max but not having luck. I will keep trying because it's confusing to the user