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,476
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.

Doug Steele, Microsoft Access MVP
Co-author: Access Solutions: Tips, Tricks, and Secrets from Microsoft Access MVPs, published by Wiley
Technical Editor: Access 2010 Bible, published by Wiley, Access 2013 Bible, published by Wiley.
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: 28th July 2014 - 05:19 AM