Totals

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

Guest

I'm stumped. I have an unbound control that looks like this:

=IIf([Date Report Rcvd]-[Date Claim Rcvd]>45,1,0) ---this is working ok

The field is currently located in the detail section of my report. Date
Report Rcvd and Date Claim Rcvd are both fields located in the same table. I
need to come up with a percentage of how many records are 1 and how many are
0. I have no idea how to do this. There are no groupings on my report.
Thanks
 
Try this for one calc:
=Sum( Abs([Date Report Rcvd]-[Date Claim Rcvd]>45) ) / Count(*)
And
=Sum( Abs([Date Report Rcvd]-[Date Claim Rcvd]<=45) ) / Count(*)

These should work in a Group or Report Header or Footer.
 
It worked perfectly! Thanks!

Duane Hookom said:
Try this for one calc:
=Sum( Abs([Date Report Rcvd]-[Date Claim Rcvd]>45) ) / Count(*)
And
=Sum( Abs([Date Report Rcvd]-[Date Claim Rcvd]<=45) ) / Count(*)

These should work in a Group or Report Header or Footer.

--
Duane Hookom
MS Access MVP
--

theitman said:
I'm stumped. I have an unbound control that looks like this:

=IIf([Date Report Rcvd]-[Date Claim Rcvd]>45,1,0) ---this is working ok

The field is currently located in the detail section of my report. Date
Report Rcvd and Date Claim Rcvd are both fields located in the same table.
I
need to come up with a percentage of how many records are 1 and how many
are
0. I have no idea how to do this. There are no groupings on my report.
Thanks
Click to expand...
Click to expand...
 
Back
Top