Average help

[Zonie32]

I have Claim_No. and two date fields, Received_Date and Response_Date. I have a DateDiff calculation to get the number of days between each date for each claim.

Now I want to find the average # of days overall claims and call that field Days_To_Respond. How do I write this?

 

[PHV]

Something like this ?
SELECT Avg(Response_Date - Received_Date) AS Days_To_Respond
FROM yourTable
WHERE Received_Date Is Not Null

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886