I want to add a text box with a control source that only pulls back a count for information entered today. I have the following code but it returns #Error
=DCount("*","STATS","Filter1 = 'filter1' and DAY(DateReceived) = DAY(NOW())")
If i use DAY(DateReceived) = '1' it returns 5 (which is correct count for the 1st)
It's the DAY(Now()) that's causing the issue.
I cant put the filter on the main query as I also have monthly total text boxes on the form.