NOW and DATE-I'm confused

[andybeeeeee]

Hi all,

I'm doing a project in access. The database is of patients of a dentist surgery and part of it is an appointment system.

Part of my project is a query that shows the people that have an appointment today. In this query i have the patients name, the time of their appointment and the appointment date fields. I want it so that, when the query runs, it displays only todays appointments.

What function do i use for this? is it NOW or something else? any help would be great! thanks!

 

[GHolden]

In your query you just need Appointment Date = Date()

Assuming your appointment date is of date type.

The difference between Date() and Now() is that Date() returns only the current date and Now() returns current Date and Time.

There are two ways to write error-free programs; only the third one works.