Patty
You can just add the two together. Something like:
Total_25_3: IIf(ProductSize=2.5 Or ProductSize=3, Sum([WeightIn]))
Regards,
Bill Mosca,
Founder, MS_Access_Professionals
That'll do IT http://thatlldoit.com
MS Access MVP
http://mvp.microsoft.com/en-us/mvp/Bill%20Mosca-35852
My Nothing-to-do-with-Access blog
From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of patrinod
Sent: Friday, January 22, 2016 12:07 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Report footers
Hello All:
Report question
We make a product in three sizes - 2.5", 3.0" and 4.0"
There is a report for yield analysis that has a ProductSize header, a detail section, a ProductSize Footer and a Report Footer
The ProductSize header shows the [ProductSize]
The Detail section shows detail data for all withing the size - ie: DateMade, ProductSequence, WeightIn, WeightShipped etc.
ProductSize footer: shows a summary for Product Size - ie: Total WeightIn: (Sum([WeightIn]), Total WeightShipped: (Sum([WeightShipped]), Yield: Sum([WeightShipped])/Sum([WeightIn])
Report Footer: shows a summary for all Product Sizes
Everything works as expected, listing all ProductSequence data within a size, then the summary for that size, then the next size, next summary, next size, next summary, and summaries for all sizes in the report footer.
PROBLEM:
Management wants to continue showing data for each size as we have now but wants another summary after the 3.0" summary that shows the combined summary for ProductSize = 2.50 and ProductSize = 3.00.
Is this possible?
TIA,
Patty
Posted by: "Bill Mosca" <wrmosca@comcast.net>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (2) |
Tidak ada komentar:
Posting Komentar