Solved Dcount with criteria of <= date() (1 Viewer)

[ypma]

Assistance is required, I have text box on a from which I wish to display the number or records within a query, where the Due Date is before or equal todays date.

=DCount("DueDate","TaskChasePackTwo") records the count of Due date, but when adding a criteria =DCount("DueDate","TaskChasePackTwo";" duedate < = date() ") i
I receive a syntax error message . How should i be applying this criteria ?

 

[arnelgp]

you have semicolunm ( there.
use comma (,)

=DCount("1","TaskChasePackTwo", "duedate < #" Format$(Date(), "mm/dd/yyyy") & "#")

 

[ypma]

Arnelgp thank you , I was comma blind , when changing the semicolons to a commas problem solved , In my example there was a typo in that an extra i was added at the end of my Dcount . thanks again for your prompt solution .

Regards Ypma