S sadie Registered User. Local time Today, 20:29 Joined Apr 11, 2003 Messages 115 Oct 16, 2003 #1 I have a field with length of stay for clients in a residence How can I get the average of the field either in a report or the query
I have a field with length of stay for clients in a residence How can I get the average of the field either in a report or the query
Fuga Registered User. Local time Today, 21:29 Joined Feb 28, 2002 Messages 566 Oct 16, 2003 #2 In the query design view, click the summation button in the toolbar. A new line appears called total. There you can choose sum or avg or something. Fuga.
In the query design view, click the summation button in the toolbar. A new line appears called total. There you can choose sum or avg or something. Fuga.