Recent content by shoggy

I will not store it then. I just need to know how to calcuate the total amount and I can run it each time!!

If you can tell me how to go about it then that would be of great help!!

I am going to store this in a field called feetotal

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...

I haven't said that it was working, I said that I can calculate the total waiting time for each person, but not the average waiting time for everyone.

I keep getting a negative figure back when I run this

I still can't get the average time to work in my query. Could anyone give an example please??:( :(

I've got it work across midnight with with the following Total Waiting Time: Format([Time Arrived]-1-[Time Left Department],"Short Time")

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...

Cheers, Thanks very much:) :) :)

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...