Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    Jul 2003
    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
    Thanked 28 Times in 28 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