Recent content by hights

Thanks BlueIshDan, works perfectly. exactly what I needed !

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

Or in the query criteria put ....Is not null

Richhol, In the properties of the table you are importing to change the Validation rule "Allow Zero Length" to NO. This should then not import blank columns.

Hi Plog, I have tried the datediff and it will calculate the difference between the start and finish time,(unless I am doing something wrong) - what I want is the time between when they finish a job and start a new job for example in red below.... Name Start Finish aaa 14:07 14:09 aaa...

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

your a genius !!! -Thanks for your help. Sorry for posting the thread in the wrong forum.

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.

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.