I have written a query that adds a group of times together. Unfortunately when the result should be 25 hours for example the database shows 1 hour. I assume every 24 hours the system reverts back to zero.
In excel to prevent this formatting cells to "[hh]:mm" solves the problem but this doesn't appear to work in access. Is there some other way?
In excel to prevent this formatting cells to "[hh]:mm" solves the problem but this doesn't appear to work in access. Is there some other way?