Results 1 to 2 of 2
  1. #1
    srbooth is offline Novice
    Windows XP Access 2000
    Join Date
    Feb 2010
    Posts
    1

    Calculate average in a query

    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

  2. #2
    MAF4Fam6's Avatar
    MAF4Fam6 is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Dec 2009
    Location
    Fruit Heights, Utah USA
    Posts
    140
    1. Create a simple Select query (default).
    2. Select your table.
    3. Drag the following fields into your Query Design grid:

    [Salesman]
    [New]
    [Used]
    [Gap]

    4. Then, create a calculated field on the 5th column in the Query Design Grid.
    Type the following in the Row called Field:

    Code:
    Average: ([New]+[Used]+[Gap])/3
    -RC

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Rounding the Average in a Query
    By jakelufkin in forum Access
    Replies: 3
    Last Post: 06-19-2009, 08:31 PM
  2. Calculate problem in query
    By crujazz in forum Queries
    Replies: 2
    Last Post: 06-15-2009, 08:03 AM
  3. Replies: 0
    Last Post: 02-15-2009, 09:14 PM
  4. Select query for Exponential Moving Average.
    By krishna79 in forum Queries
    Replies: 0
    Last Post: 01-22-2009, 05:52 AM
  5. Replies: 0
    Last Post: 02-14-2007, 01:35 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums