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 ?
=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 ?