counting records in a date range

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

Joyce

I have a monthly report that reflects research cases. The
report displays date received and date resolved. I need
to capture all received cases for a period of time. In my
control source for DateReceived I want to count all cases
received from 02/01/04 to 02/29/04. Any suggestions.
Thank you.
 
Joyce said:
I have a monthly report that reflects research cases. The
report displays date received and date resolved. I need
to capture all received cases for a period of time. In my
control source for DateReceived I want to count all cases
received from 02/01/04 to 02/29/04.
Click to expand...

Not sure I understand what you want here, but try using a
text box in the report footer section. Set its control
source expression to:
=Abs(Sum(DateReceived Between #02/01/04# And #02/29/04#))

If that gives the result you're looking for, post back with
more information about how the report is opened, etc. and
we'll see if there's a way to parameterize the dates so you
don't have to change the report every month.
 
Back
Top