calculations on my report!

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
Thanks alot that worked very well.

Thanks for the calculations check!

Duane Hookom said:
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.
Click to expand...
 
Back
Top