Jumat, 22 Januari 2016

[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



__._,_.___
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (1)

.

__,_._,___

Tidak ada komentar:

Poskan Komentar