Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Unable to count by multiple fields in Report

Status
Not open for further replies.

Qino

Technical User
Mar 15, 2007
7
US
I've had great difficulty getting my report to provide a breakdown of totals by three fields, and calculate the final field. I can get a total count no problem, but several dead-ends and now I need a push in the right direction:

I have this:
Type Quality Size
20 A 22x22
20 A 22x22
20 A 33x33
20 A 22x22
25 A 22x22
26 A 22x22
26 Z 22x22

I need this:
Type Quality CombinedSize
20 A 1452sqft 3pc
20 A 1089sqft 1pc
25 A 484sqft 1pc
26 A 484sqft 1pc
26 Z 484sqft 1pc

I need the breakdown sorted by Type, then Quality then Size and then report the count for those items.

Any gentle nudges will be welcome.

Qino
 
About 3 hours after I posted I ran a second query on the same data which totaled exactly as I needed and did the calculated field. I just added it to the report as a sub-report. It seems so obvious now.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top