Report Calculation

  • Thread starter Thread starter Joyce
  • Start date Start date
J

Joyce

I need to show on a report the count of all recoreds
(CaseID) in my database, then show the count of records
that are resolved (DateResolved) then unresulved which
would be the total of the (CaseID) less (DateResolved).
I'm not sure how to note this in the expression builder.
Any help would be appriciated. Thank you.
 
Joyce said:
I need to show on a report the count of all recoreds
(CaseID) in my database, then show the count of records
that are resolved (DateResolved) then unresulved which
would be the total of the (CaseID) less (DateResolved).
I'm not sure how to note this in the expression builder.
Click to expand...


Use text boxes in the REPORT footer section (not the page
footer). The expression for total number of records in the
report is:
=Count(*)
and an expression for the number of resolved records:
=Count(DateResolved)

If I misunderstood what DateResolved is, post back with more
info about how DateResolved is used.
 
Back
Top