time query

[Guest]

I am trying to caculate the time difference between a time stamp located in
my table and the current time.

Appointment time is located in the table and is entered by the employee.
I would like to have my query identify any appointment that has exceeded a
two hour limit.
I have been able to do this between to set dates (appointment time and
departure time) but i have been unable to do it using current time. (now()
function)

 

[Marshall Barton]

I am trying to caculate the time difference between a time stamp located in
my table and the current time.

Appointment time is located in the table and is entered by the employee.
I would like to have my query identify any appointment that has exceeded a
two hour limit.
I have been able to do this between to set dates (appointment time and
departure time) but i have been unable to do it using current time. (now()
function)

DateDiff("n", [appointment time], Now) >120)

 

[Guest]

Thank you!!!!!!!!

I am trying to caculate the time difference between a time stamp located in
my table and the current time.

Appointment time is located in the table and is entered by the employee.
I would like to have my query identify any appointment that has exceeded a
two hour limit.
I have been able to do this between to set dates (appointment time and
departure time) but i have been unable to do it using current time. (now()
function)

DateDiff("n", [appointment time], Now) >120)