Query showing averages for groups

[AnthonyTesta]

I have a table that contains various test results for the same model golf shaft. I would like to have a query that would show each Model only once yet have an average for the various amount of tests performed. Can this be done without a lot of code?

It seems like it should be simple... To state it another way I would like for the Model "Aldila NV 65 S" and "Aldila NV 65 X" to show up in a query only once but the other colums ie. 41", 36", etc to have the average of the tests performed.

If anyone could help, it would be greatly appreciated.

Anthony

[NassauBob]

So, let me see if I understand what you want...

you would like to see each club, with an average of each of the numeric fields to follow?

SELECT Model, AVG(41"), AVG(36"), ... AVG(11")
FROM TABLE_NAME
GROUP BY Model

That outta do it.

BTW, are those the column names above, or just caption values, and not the actual column names? Because it is very not good programming practice to have punctuation marks in column names. Not busting on you, honestly, really wanting to help you to avoid headaches down the road. :-)

P.S. you may also want to remove the "Aldila" portion from the model number field, because it appears to be redundant data from the manufacturer column, and will take up (what seems to be) unnecessary storage space in your database.

Shane