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

Welcome Guest ( Log In | Register )

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

New Member
Posts: 4

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
Post #2

UtterAccess VIP
Posts: 18,349
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.

This post has been edited by Doug Steele: Feb 22 2011, 09:22 AM
Go to the top of the page

Posts in this topic

Thank you for your support! Reply to this topicStart new topic

Jump To Forum:

RSS Search  ·  Go to Top  ·  Lo-Fi Version Time is now: 17th April 2014 - 02:47 PM