Report Calculation

[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.

 

[Marshall Barton]

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.

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.