Finding all appointments today: wierd behaviour!

[not_rich_yet]

Hmm, I owuld have thought this was an easy one!

I have a table which holds appointment details, one of these details being the appointment date in Medium Date format.

I attempted to create a query which would list all appointments today so I created a query based on the appointments table and added the =Now() criteria to the column in the query holding the Appointment Date value....I definetly have appointments today, yet when I run the query it gives me no data at all! If I remove the =Now() criteria it does as expected: lists all appointments....

Can anyone shed any light on this wierd problem? Quite wierd in my opinion!

 

[David R]

Now() includes date and time, that's why it's not matching. Try =Date()

 

[not_rich_yet]

Now I feel stupid! I forgot about Date()!

Cheers for the proverbial kick in the right place!

nry