Need Help with DSUM syntax

[Guest]

Sorry to create a new thread on this but I tried putting it on the old one
and it didn't work.

You did so well on my other DSUM problem that one I wondered if I could get
your help again on a variation of that same Dsum statement. The last one
(shown below) totalled records between a range of dates. For this one I need
to total all records less than or equal to the ENDING date [Enter Ending
Date] field.

Here's the syntax I wrote, but it brings back ZERO each time. Is there
something wrong with it?

=Format(Nz(DSum("dailyHours","attendance_clock_in","studentid=" &
[employeeid] & " And [date]<= " & [Enter the Ending Date
(mm/dd/yyyy)]),0),"Fixed")

=Format(

Nz(
DSum("dailyHours","attendance_clock_in",
"studentid=" & [employeeid] &
" And [date] Between #" & [Enter the Beginning Date] &
"# And #" & [Enter the Ending Date ] & "#"),0),"Fixed")

 

[Duane Hookom]

Reply in your other post.

--
Duane Hookom
MS Access MVP

Sorry to create a new thread on this but I tried putting it on the old one
and it didn't work.

You did so well on my other DSUM problem that one I wondered if I could
get
your help again on a variation of that same Dsum statement. The last one
(shown below) totalled records between a range of dates. For this one I
need
to total all records less than or equal to the ENDING date [Enter Ending
Date] field.

Here's the syntax I wrote, but it brings back ZERO each time. Is there
something wrong with it?

=Format(Nz(DSum("dailyHours","attendance_clock_in","studentid=" &
[employeeid] & " And [date]<= " & [Enter the Ending Date
(mm/dd/yyyy)]),0),"Fixed")

=Format(

Nz(
DSum("dailyHours","attendance_clock_in",
"studentid=" & [employeeid] &
" And [date] Between #" & [Enter the Beginning Date] &
"# And #" & [Enter the Ending Date ] & "#"),0),"Fixed")