time calculation in access

[itsmythg]

i have a log that i am running reports against it has a field, "Time" data is import as date/time shows in table as 01:00:00 i need to run a report only showing the last 24 hours of activity. I would really appreciate help with this.

 

[SkipVought]

Hi,

Time is the fractional part of Date.

Time is in DAYS.

24 hrs previous from [YourTime] is

StartTime: [YourTime] - 1

Skip,
^{Don't let the Diatribe...
talk you to death!}
_{Just traded in my old subtlety...
for a NUANCE!}