X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
> Time Counter    
post Feb 22 2011, 06:06 AM

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
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
Go to the top of the page
Start new topic
Doug Steele
post Feb 22 2011, 06:15 AM

UtterAccess VIP
Posts: 21,790
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

Custom Search
RSSSearch   Top   Lo-Fi    25th June 2018 - 10:27 AM