Hi i have written a simple database to hold values from 1 - 5 .. The 

number of rows (data) can be whatever depending on the date range.  So 

which would be the best way to calculate the average?



URGENT please help.

You can use the Wizard to Create the new query quickly and easily.



1) In the Database window, click the Queries tab, and then click New.

2) In the New Query dialog box, click Simple Query Wizard.

3) Click OK.

4) Click the name of the table or query you want to base your query on, 

and then select the fields whose data you want to retrieve.

5) Click Next

6) You will be presented will be presented with a form asking you "Would 

you like a detail or summary query."

7) Click Summary.

8) Click Summary Options

9) Select required summary options for the required field (sum, average, 

minimum, maximum)

6) Click OK

7) Click Next

5) Follow the directions in the wizard dialog boxes.

6) In the last dialog box, you can choose either to run the query or to 

see the query's structure in Design view. Choose Design View.

7) Click "Open the query to see information"

8) Click Finish



DONE!





_____________________________________



John Fejsa

Systems Analyst/Computer Programmer

Hunter Centre for Health Advancement

Locked Bag 10

WALLSEND NSW 2287

Phone: (02) 49246 336 Fax: (02) 49246 209





>>> pritesh_b@t... 06/04/2001 2:24:16 >>>

Hi i have written a simple database to hold values from 1 - 5 .. The

number of rows (data) can be whatever depending on the date range.  So

which would be the best way to calculate the average?



URGENT please help.

You can do it in a query--here's the SQL.



If the field is called "value" and the table is called "table" then:



SELECT AVG(Value) FROM Table ;



-----Original Message-----

From: pritesh_b@t... [mailto:pritesh_b@t...]

Sent: Thursday, April 05, 2001 9:23 AM

To: Access

Subject: [access] Average on a table





Hi i have written a simple database to hold values from 1 - 5 .. The 

number of rows (data) can be whatever depending on the date range.  So 

which would be the best way to calculate the average?



URGENT please help.