Results 1 to 7 of 7
  1. #1
    Join Date
    Mar 2003
    Posts
    4

    Unanswered: calculating tthe average on a query

    Hi,

    I am a new acces user. I have problem with calculating the average and counting the datas in a query. I also checked the Help but I couldn't solve my problem.
    Will you please explain me with details how to get the average of a column on my query?

    Thanks for your replies.

  2. #2
    Join Date
    Sep 2002
    Location
    South Wales
    Posts
    580

    Totals query

    Right click the query design grid (the bit you drag fields onto)


    Left-click totals

    Another option appears with "avg" as one of the parameters

    Drag the field you want to find the average for and select avg for this filed.

    Hope that helps

  3. #3
    Join Date
    Mar 2003
    Posts
    4
    Thanks for your help.
    I did waht you said but I can not seethe average value of the field. How can I see this average value.

    As I mentioned before I am a beginner . This can be very easy but I can see.

    Benay

  4. #4
    Join Date
    Sep 2002
    Location
    South Wales
    Posts
    580

    More information

    Please advise name of TABLE that field is in you want the average for

    >

    Please advise name of the FIELD itself

    >

    I will then post more detailed info

  5. #5
    Join Date
    Mar 2003
    Posts
    4
    Table nameost adress
    field name:frequency

    Thanks for your prompt reply.

    Benay

  6. #6
    Join Date
    Sep 2002
    Location
    South Wales
    Posts
    580

    Table name?

    I think table name was: post address
    Field name: frequency

    Click queries

    Click New

    Click design view

    Close "show table" selection box

    Click view:sql

    Copy and pase this:

    SELECT Avg([post address].frequency) AS AvgOffrequency
    FROM [post address]
    WITH OWNERACCESS OPTION;

    Click view design

    Run / save report

    This will return the average of that field

    I would recommend investing in a good access book if you can afford it.

    There are many available, Im sure others will suggest some for you.

    ONE I have is "Mastering access 2000 development" by Alison Balter, although as I say there are many available...
    Windows Server 2003-8 / Terminal Services / SQL 2000 / Access 2003 / Office 2003-7 / Exchange 2003-7 / Blackberry Enterprise Server / AutoCAD / Lambert And Butler / Red Bull

  7. #7
    Join Date
    Mar 2003
    Posts
    4
    Yes it works. Thanks for your help.

    I have some books but I can not find detailed informations liske this.

    Thanks for your advise.

    Benay

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •