I have a report designed in Access 97. There are several caculated fields on this report. I am having trouble with this one.
1. Total Hours To Date
=Format(Nz(DSum("dailyHours","attendance_clock_in","studentid=" & [employeeid]),0),"0.00")
How the report works: I run this report using a...