compare dates

[Cynthia]

I am trying to send out notices of past due items.
my table holds duedates such as 12/4/2007 10:59:30 AM
when I run a query where currdate which is a date & " " time
is less than duedate, but my query comes back blank?

 

[Linq Adams via AccessMonster.com]

We can't begin to tell what's wrong with your code unless we can see it!

 

[Cynthia]

Okay, I just found out my problem was I had 'vardate' in my vb code and I
needed #vardate#. Sorry to take your time.