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 bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Current Date and time Minus Earliest Time

Status
Not open for further replies.
Gizmo0917

Gizmo0917

Technical User
Dec 5, 2003
43
US
I have two tables TableInfo and UseageLog the Useage log has start date and time. On my form a patient may have several Start Date and times. I want to take the current date and time meaning the time that I open up my form and subtract the earliest start date and time. Then if it totals to 96 hours I need to flag the records that meet this creteria and show me the record number. We will then fill out a form for billing as we do not bill over 96 hours. I also need a button the record closed so that when I run the query it will not come up when everytime the query is run. A toggle button to close or open would be ideal as after 96 hours they get up to 30 days free and then we start billing again. Can this be done? I already have the form which consists of both tables.
Thanks!

 
Status
Not open for further replies.

Similar threads

C
  • Question
Run-time error '3075': Syntax error (missing operator) in query expression 'Birthday = and Birthmonth ='.
Replies
3
Views
263
OzFoxy
OzFoxy
datajockey123
  • Locked
  • Question
Note / Information box with date and time stamp for each entery
Replies
2
Views
776
dhookom
dhookom
monkeysee
  • Locked
  • Question
Max Date Qry 1
Replies
3
Views
857
Andrzejek
Andrzejek
BugZap13
  • Locked
  • Question
Need help creating a date from two fields to be used in where clause
Replies
5
Views
582
mikrom
mikrom
caykamanj1966
  • Locked
  • Question
Get Yesterday's Date
Replies
1
Views
512
caykamanj1966
caykamanj1966

Part and Inventory Search

Sponsor

Back
Top