Avg Query

[dadrew]

I have created a query that works out an Average Elapsed time. I have a form that is set up as continuous. I want to show this average time in a text box in the header, but I cant get it to show the results I just get #Name# in the box. Can someone help?

 

[KeithWilliams]

If your elapsed time in the details is called ElapsedTime, the following should work (don't forget the = sign):
=Avg([ElapsedTime])

HTH,
Keith.

 

[dadrew]

Cracked it, thanks