DCount and DLookup with Date

[Alec]

Hi All,

I am trying to use the DCount and DLookup functions with the WHERE
expression set to: "DateToDo <= #" & Date & "#" to display all items
with their DateToDo set to the current date or earlier than the current
date. However, it is still returning 0 as the number counted? Is there
some other way to compare records with dates to the system date for
counting?

Thanks in Advance!

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[Allen Browne]

You should be able to use:
"[DateToDo] <= Date()"

If there is a time component in the DateToDo, try:
"[DateToDo] < Date() + 1"

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Alec" <alec_e_christie at hotmail dot com> wrote in message
news:41**********************@news.newsgroups.ws.. .

I am trying to use the DCount and DLookup functions with the WHERE
expression set to: "DateToDo <= #" & Date & "#" to display all items
with their DateToDo set to the current date or earlier than the current
date. However, it is still returning 0 as the number counted? Is there
some other way to compare records with dates to the system date for
counting?

[Fred Zuckerman]

Are you sure that your [DateToDo] field/variable is dimmed as date?
Fred Zuckerman
"Alec" <alec_e_christie at hotmail dot com> wrote in message
news:41**********************@news.newsgroups.ws.. .

Hi All,

I am trying to use the DCount and DLookup functions with the WHERE
expression set to: "DateToDo <= #" & Date & "#" to display all items
with their DateToDo set to the current date or earlier than the current
date. However, it is still returning 0 as the number counted? Is there
some other way to compare records with dates to the system date for
counting?

Thanks in Advance!

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[Alec]

Thats wonderful, worked a treat.

Thanks for the help!
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!