UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

> Time Counter    
 
   
JayeB
post Feb 22 2011, 06:06 AM
Post#1



Posts: 4
Joined: 22-February 11



Hi Guys
I have checked through and couldnt see anything relevant so posting a new question
I have a very simple request but for the life of me can not find the answer. Using Access 2003, I need to be able to display how long a tcket has been open and then creat a query to show every record over a certain time
Example
Field [Time Logged]
I then want another field that shows how many hours it has been since [Time Logged] and then create a report to display all records where [Time Logged] is over 10 hours
Many thanks in advance for any answers or pointers to a more suitable referance
Jaye
Go to the top of the page
 
 
Start new topic
Replies
Doug Steele
post Feb 22 2011, 06:15 AM
Post#2


UtterAccess VIP
Posts: 18,862
Joined: 8-January 07
From: St. Catharines, ON (Canada)


Look at the DateDiff function.
Create a query that retrieves the various fields from your table. Add a computed field to that query, something along the lines of
Duration: DateDiff("h", [Time Logged], Now())
Put >10 as the criteria under that field.
Go to the top of the page
 

Posts in this topic



RSSSearch   Top   Lo-Fi    27th May 2015 - 06:47 PM