counting records in a date range

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

 

[Marshall Barton]

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.

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.