Search results

Hi, Wonder could anyone help me…haven’t used Access for a while and I’m a little rusty :confused: :confused: I am trying to run a query where I need to calculate the total amount of money received between two dates. My field are DateReceived and FeeAmount. For example I need to calculate the...

Hi, I need to calculate an average waiting time for patients waiting to be seen in an A&E dept between two dates. I have calculated the total waiting time for each patient with the following formula Total Waiting Time: Format([Time Arrived]-1-[Time Left Department],"Short Time"). Any help...

Calculate time across midnight in ms access -------------------------------------------------------------------------- Hi, I have created a database to store patient arrival date, arrival time and departure time. I am trying to set up a query to calculate the total waiting time for each...