G
graemej
Guest
I am trying to create a query that will show jobs that have exceeded a given time. So far I have managed to use the dispatched time and completed time fields to return a value that shows how long a job took. My problem is that I only want to view jobs that have exceeded 3 hours, I have tried entering in the criteria field > #03:00# but this dosent seem to return the expected data.
Please help. Many Thanks
Graeme
Please help. Many Thanks
Graeme