AVERAGE A LIST OF YEARS IN A QUERY

[burton99]

I have created a query that give me information on vehicles including the year of the vehicle.

How can I take all the years that the query pulls and get an average for all of them?

Each time I try to average them it tell me that it can't because of an invalid data type.

I can create the query so that it will give me the amount of each year for the group of records my query pulls but I can't get an ending result that displays just one year (the average of all of them put together).

Any help would be greatly appreciated. Thanks.

Holly

 

[IFELSETHEN]

Hi, just a thought. If you can get a query to give you the avg years for the vehicle then use that query as a sub-query in your select statement. Check out sub-querys.

John