Averages in a query

[srbooth]

I have a table that stores Salesmans sales results by type. What I want to do is calculate the aveage sales by salesman and show results in a query.

The fields in the table are [Salesman] [New] [Used] [Gap] in a table called results



-----------New-----Used----Gap----Average

Rob----------2 --------6 ------9-------- ?

Dave---------6------- 7 ------3---------?

Pete ---------8------- 5------ 1-------- ?

Thanks

 

[John Big Booty]

One of the available options in a Totals (Σ) query is average, that should provide the result you are looking for.

 

[srbooth]

Wouldn't that just average the values in a column? I'm looking for the average of the values in the row

 

[Brianwarnock]

How about
(new+used+gap)/3

Brian

 

[srbooth]

Never thought of that one.

Thanks