Do more with
WHERE [DateField] = #11/25/2019#
or WHERE [DateField] = Date()
If, however, you use the Now() function to fill in the date field, then you need to either convert that value to a date only, or use a date range.WHERE DateValue([DateField]) = Date()
orWHERE [DateField] >= Date() AND [DateField] < DateAdd("d", 1, Date())
Premium Content
You need an Expert Office subscription to comment.Start Free Trial