Date & Time Problem

[Mary/Phil Stewart]

I have a small Access 2k application that lists a number of terminals that
are contacted daily. The time & date field is formatted as: mm/dd/yyyy
hh:mm:ss. Presently, I have a query that lists the terminals not contacted.
I am using a criteria entry of <date(). The query shows those units last
contacted yesterday. I would like to list the terminals not contacted within
the last 24 hours.
Can someone help? Thank you.
Phil Stewart

 

[Ken Snell]

Use a calculated field:
DateSince: DateDiff("h", [DateFieldName], Date())

Then use a criterion of ">24" for this calculated field.

 

[Douglas J. Steele]

You probably want to use Now() instead of Date().

--
Doug Steele, Microsoft Access MVP

(No private e-mails, please)

Use a calculated field:
DateSince: DateDiff("h", [DateFieldName], Date())

Then use a criterion of ">24" for this calculated field.

--
Ken Snell
<MS ACCESS MVP>

I have a small Access 2k application that lists a number of terminals that
are contacted daily. The time & date field is formatted as: mm/dd/yyyy
hh:mm:ss. Presently, I have a query that lists the terminals not contacted.
I am using a criteria entry of <date(). The query shows those units last
contacted yesterday. I would like to list the terminals not contacted within
the last 24 hours.
Can someone help? Thank you.
Phil Stewart

 

[Ken Snell]

You probably want to use Now() instead of Date().

Yep! Thanks, Doug.