Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

time calculation in access

Status
Not open for further replies.
itsmythg

itsmythg

Technical User
Apr 4, 2001
34
0
0
US
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.
 
Sort by date Sort by votes



Hi,

Time is the fractional part of Date.

Time is in DAYS.

24 hrs previous from [YourTime] is
Code: 
StartTime: [YourTime] - 1

Skip,
[sup][glasses]Don't let the Diatribe...
talk you to death![tongue][/sup][sub]
[glasses]Just traded in my old subtlety...
for a NUANCE![tongue][/sub]
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Xavierparkash
  • Locked
  • Question
MS Access Slow Search in Linked Database
Replies
0
Views
85
Xavierparkash
Xavierparkash
PrimoSteve
  • Locked
  • Question
Fill in 2nd Textbox2 from Textbox1
Replies
3
Views
120
PrimoSteve
PrimoSteve
JanaLNelson
  • Locked
  • Question
Filter as you type combo box in Access 2
2 3
Replies
54
Views
458
JanaLNelson
JanaLNelson
caykamanj1966
  • Locked
  • Question
Duplicate Records in DataSheet View
Replies
5
Views
120
Andrzejek
Andrzejek
leifoet
  • Locked
  • Question
How to store decimal numbers in an Access database?
2
Replies
27
Views
293
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top