Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    Feb 2006
    Thanked 0 Times in 0 Posts

    Access Averages in Reports (Professional Edition 2003)

    I am creating a report to see the satisfaction average for 3 of my training centers. I set this report up but know want to know what the average is but want to leave out 2 classes from one location. How would I set this up ?
    Thank You !

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Thanked 31 Times in 31 Posts

    Re: Access Averages in Reports (Professional Edition 2003)

    Welcome to Woody's Lounge!

    You can probably use the DAvg function. The expression would look like this:
    =DAvg("Satisfaction", "NameOfTable", "ClassID Not In (3, 12)")

    NameOfTable is the name of the table containing the data.
    Satisfaction is the name of the field that contains the ratings.
    ClassID is the name of the field identifying the classes.

    If a name contains spaces or punctuation, put square brackets around it, for example <code>[Class ID]</code>

    In the above, I assumed that ClassID is a number field. If it is a text field, put single quotes around the values:
    "ClassID Not In ('Math 101', 'English Lit')"</code>

Posting Permissions

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