Usage Report

[deanwat]

I have a table and form that looks like the table below I am trying to figure out to do a monthly report, daily and who visited most like that dose anyone have any idea. I really need some help.

Check in # = AutoNumber
Group ID = text
Indiv Id = text
Date = Date

 

[statsman]

I assume you are running this report from a query.

In the criteria of the DATE field in the query enter the following:

Between >=[Start Date] And <=[End Date]

The query will prompt you to enter a Start Date and End Date. You can select the dates to print the report for...could be daily, weekly, monthly or whatever period you enter in your start and end dates.