I have a table that stores Salesmans sales results by type. What I want to do is calculate the average sales by salesman and show results in the query.
The fields in the table are [Salesman] [New] [Used] [Gap] in a table called results
Salesman --------New-----Used----Gap------Average
Rob -----------------2--------6 -------9 ----------?
Dave ---------------6 --------7------- 3---------- ?
Pete ----------------8---------5-------1-----------?
Thanks