Hi Folks.
I'm losing my mind on a database I've put together. I need to track the men in the workshop, what they are doing and how long they are doing it.
I have a report for summarising the time they spend on each task but it wont add duration's greater than 24 hours. It basically resets itself back to 24 hours and doesn't add the time correctly. I know this must be a simple solution but I'm poor at SQL and have wing-ed my way this far.
I've created a report called 'all projects on a page'
Could anyone help please. I'm at a standstill. I have attached a link to the database if anyone can assist...
https://www.dropbox.com/s/0jsr6ltitf...ues.accdb?dl=0
Many thanks in advance.
Al