Average (Again)

[Eric]

Here is my question,
I have 2 fields in my database one is "Arrive" (the time the nurse arrived
at the patient's home), the other field is "Coded Time" (the time the
referral is coded). So I want to get the time difference between the
"Arrive" and "Coded Time" and then average it... this is what I used:
DateDiff("y", [Arrive], [Coded Time])
I do not recieve an error, but nothing displays when I run the query...what
am I doing wrong?

 

[Jerry Whittle]

It runs fine for me in a query. What's the SQL statement for your query?

What happens when you do a Ctrl + g and put the following in the Debug.Print
window then hit Enter?

Debug.Print DateDiff("y", #2/1/2008#, date)