dlookup not working for other month than MAY

Question

I am using dlookup (date = date) its fine when the date is of "May" but when I put date of any other month like 1/6/19 the dlookup remains silent.

in Dlookup if date is of MAY its fine but not working when date id of JUN the code I am using is as below Me

Total = DLookup("Total", "Dailycash", "Cdate =#" & sdate & "#")

Your question is not clear. Please follow https://stackoverflow.com/help/how-to-ask — Olympiloutre, Jun 06 '19 at 05:04

score 0 · Answer 1 · answered Jun 06 '19 at 10:05

0

Apply a proper format to the date value expression:

Total = DLookup("Total", "Dailycash", "Cdate = #" & Format(sdate, "yyyy\/mm\/dd") & "#")

answered Jun 06 '19 at 10:05

Gustav

1 Answers1