Sabtu, 23 Januari 2016

RE: [MS_AccessPros] Report footers




You can just add the two together. Something like:

Total_25_3: IIf(ProductSize=2.5 Or ProductSize=3, Sum([WeightIn]))


Bill Mosca,
Founder, MS_Access_Professionals
That'll do IT
MS Access MVP

My Nothing-to-do-with-Access blog


From: [] On Behalf Of patrinod
Sent: Friday, January 22, 2016 12:07 PM
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.


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? 







Posted by: "Bill Mosca" <>
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (2)



Tidak ada komentar:

Posting Komentar