View Single Post
  #4 (permalink)  
Old October 17th, 2003, 02:47 PM
stoneman stoneman is offline
Authorized User
 
Join Date: Jun 2003
Location: , , .
Posts: 47
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Since there is a DateIn field that is automatically entered she could build a report where the RecordSource is a query having the fields he wants including the DateIn field. He could use an unbound form where the user can select a specific date or between two dates as parameter to DateIn field of this query.

Put an unbound textbox in the report detail section.
Set the RecordSource to =1
Set the RunSum set to OverGroup or OverAll depending on how he watts the data.

This will display the count for each day
Hope this helps.
Reply With Quote