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

ypma

Registered User.
Local time
Today, 22:44
Joined
Apr 13, 2012
Messages
638
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

..forever waiting... waiting for jellybean!
Local time
Tomorrow, 06:44
Joined
May 7, 2009
Messages
14,607
you have semicolunm (;) there.
use comma (,)

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

ypma

Registered User.
Local time
Today, 22:44
Joined
Apr 13, 2012
Messages
638
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
 

Users who are viewing this thread

Top Bottom