Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    Jul 2003
    Posts
    9
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Statistics on a table's data (2000)

    I have a table I want to collect data on. For
    example, "how many of the entries have the value "X" for
    such-and-such field in the table?" Any way I can publish
    some kind of a report with such statistics? Thanks.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Statistics on a table's data (2000)

    You can calculate sum, count, average and things like that in a Totals query, then create a report based on the Totals query.
    The Report Wizard also offers the option to group records and to calculate group sums, counts and averages.
    Most Access basics books explain this in detail.

Posting Permissions

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