Microsoft access 97. No other software.
I have made a "table" with 6 "fields" .
How can I make a query ? preferably one
than uses "average" for one of my fields ?

You need to create a select query. First of all, click on the Queries tab. Next, choose New. Click on design view, then OK. Double click on the table name. If you are using all six fields for the query, then double click the table name in the title bar. Click on the first field and drag that to the grid. If you only want certain fields, then just drag them to the grid. For the average, create a new field. e.g. Average:FieldNameToAverage. Click on the sigma sign on the toolbar, this is for totals. Click on the row that contains your new field. You should see a dropdown box. Just choose Avg. Save and run the query. That should do the trick. I hope that I havn't gone overboard with the explanation.

David