Statistics for comparison of two Date Fields 1

[sbbrown9924]

I have an encounter database that logs all the important milestone times when a patient is seen in an ER. These times are TriageTime, InRoomTime, DischargeTime, etc.

How would I write a query that performs statistics (min, max, avg, stdev) on the DateDiff of two date fields in a table across all encounters?

 

[dhookom]

You can add and subtract times like you would numbers. Totals queries allow you to perform Min, Max, Avg, and StDev.

SELECT Min(DateDiff("n",TriageTime, InRoomTime)) as MinTR,
StDev(DateDiff("n",TriageTime, InRoomTime)) as StdTR
From SomeTable;

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[sbbrown9924]

dhookum;

my apologies, I think I forgot to thank you for the help.