Average numbers in a query???

[TeeBruin]

I have a parameter query, where the user is prompted for a week number, and the query displays a list of all records with the inputted week number. The query will display the response time (in days) and week number for all records. I need to get an average response time for all the records in the query. Is there a way to do this in the query, or does it have to be done in a report?

 

[hsitz]

Try clicking on the summation symbol button (the one that looks somewhat like an E) on the toolbar in query design mode. This will give you an extra row in your query design where you can specify one of the columns to be an average. -- Herb