calculations on my report!

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

JOM - 09 Jan 2006 19:52 GMT

my information on the report comes from a crosstab query, I want to do some
calculations on the report footer but am not sure how to... ie the
ontime/total produced

W2 1040 1099
OnTime: 35 43 10
OutStd : 22 58 8
------------------------------------
Total Produced: 77 101 18 (=OnTime+outstd)
------------------------------------------------------------
service level: 45.45% 42.57% 55.56% (ontime/total
produced

Reply to this Message

Duane Hookom - 09 Jan 2006 20:33 GMT

I assume you have a field with values of either OnTime or OutStd. Assume
this field is named [Status].
A guess might be a control source like:

=Sum(Abs(Status="OnTime") * W2)/Sum([W2])

BTW: W2 Total Produced should be 57, not 77.

Signature

Duane Hookom
MS Access MVP
--

> my information on the report comes from a crosstab query, I want to do
> some
[quoted text clipped - 10 lines]
> service level: 45.45% 42.57% 55.56% (ontime/total
> produced

Reply to this Message

JOM - 09 Jan 2006 22:56 GMT

Thanks alot that worked very well.

Thanks for the calculations check!

> I assume you have a field with values of either OnTime or OutStd. Assume
> this field is named [Status].
[quoted text clipped - 18 lines]
> > service level: 45.45% 42.57% 55.56% (ontime/total
> > produced

Reply to this Message