connieharper
Registered User.
- Local time
- Today, 02:15
- Joined
- Sep 15, 2000
- Messages
- 17
I have an access97 report that has a field labeled [hours_to_date]. In the control source properties for this field I have the following:
=Format(Nz(DSum("dailyHours","attendance_clock_in","studentid=" & [employeeid]),0),"0.00")
This currently shows a total all attendance records for a particular student. When the report is run, I prompt the user to enter the beginning and ending dates for the report, which is generally a one month period. There are some other totals on the report that use monthly figures.
What I need is the correct syntax for the hours_to_date field so that it only totals the attendance records up to the ending date the user enters into the computer when they print this report.
Example: The user prints the attendance report for the month of June. For the beginning date they enter June 1, 2001 and for the ending date they enter June 31, 2001. The value displayed in the [hours_to_date] field should be all hours for the student from the day they started attending up to June 31, 2001.
Thanks
=Format(Nz(DSum("dailyHours","attendance_clock_in","studentid=" & [employeeid]),0),"0.00")
This currently shows a total all attendance records for a particular student. When the report is run, I prompt the user to enter the beginning and ending dates for the report, which is generally a one month period. There are some other totals on the report that use monthly figures.
What I need is the correct syntax for the hours_to_date field so that it only totals the attendance records up to the ending date the user enters into the computer when they print this report.
Example: The user prints the attendance report for the month of June. For the beginning date they enter June 1, 2001 and for the ending date they enter June 31, 2001. The value displayed in the [hours_to_date] field should be all hours for the student from the day they started attending up to June 31, 2001.
Thanks
