Search results
-
H
calculating working days
I am trying to work out standards for 3 different priorites eg... Product was booked in today 03/10/14.. Proirty 1 - needs to be worked in 3 working days Proirty 2 - needs to be worked in 10 working days Proirty 3 - needs to be worked in 30 working days I would like the query to display... -
H
excel query in access
Hi, I have a query that displays the start and finish time for an activity, I am trying to display the reults of the time between each activity.... For example Name start End aaa 14:07 14:09 aaa 14:11 14:12 The end time for the first activity was 14:09 and the next... -
H
Date Conversion
Anyone any idea how I would convert YYMMDD TO DDMMYYYY in a query? Here is an example of the date I am trying to convert.... 130820 - I want to display 20/08/2013. Thanks. -
H
Date conversion
Anyone any idea how I would convert CYYMMDD TO DDMMYYYY in a query? Here is an example of the date I am trying to convert.... 1130820 - I want to display 20/08/2013. Thanks.