I am converting multiple spreadsheets into access and have come across a problem in the way access handles time.
I have clients ,staff and appointments
I want to report the total hours for client for a given date range.
I have the query set up to display the appointments and number of hours for each, but can't work out how to put a sum of hours at bottom of report.
I have attached a names changed versioncalchours.zip