Average

[Eric]

I have 2 fields in my database that are both time fields:
One is the time we coded and the other is the time the patient was seen.
What I would like to do is do the average of the time an item was coded to
the time the patient was seen. Any suggestions.
Thanks,
Eric

 

[Jeff Boyce]

Eric

If the two fields are Date/Time-type fields, take a look at the DateDiff()
function (see Access HELP).

Use the DateDiff() in a query to get the time difference, then change the
query to a Totals query to calculate the Average.

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Ron2006]

Be sure to format the difference as a number NOT a date/time.

Usually better to compute the difference in minutes IF you want the
difference to be stated as hours.

If those fields do not contain the date then times across days may
give interesting results.
If they do contain dates and you are looking for work hours then you
will need a bunch more computations.

Ron

 

[sivak]

Try with this one.

select cvdate( (AvgDate.date1 + AvgDate.date2 ) / 2 ) from table1