DCount Dates

[Guest]

Again, I need help!

I'm trying to create a report that show how many patients were seen on a
particular day. For example I have to create a monthy report that shows the
stats for each day of the month.

I have to create a report that show how many patients were seen on each day
of the month.

I have a [PatientData] table that stores the [SSN] and [DrawDate]. The
report would look something like this:

1 10
2 15
3 22

My problem is that I want the user to be able to dictate which month the
report is for. So that they can enter 'December' and get Decembers stats...

Possible?

Thanks in advance.

 

[Van T. Dinh]

Yes but you need to be more precise with computers: you need to ask for
December of WHICH year.

Base your Report on a Total Query with suitble criteria to restrict to the
month & year you want.

Check Access Help on Total Queries (also known as Group By Queries).

 

[Guest]

In the query set the date parameter to this:

Between [Enter Start Date] and [Enter End Date]

this will cause the user to enter the dates he wants to see data for. If it
is only for one day, then the user can just enter the same date twice.