Results 1 to 2 of 2
  1. #1
    Lounger
    Join Date
    Jan 2001
    Location
    MN
    Posts
    45
    Thanks
    0
    Thanked 0 Times in 0 Posts

    SUM of items in a table

    I am a complete Access newbie and am about to demonstrate this lack of ability!

    A have a table with about 125,000 records in it. Before it grew to this length I would use Excel and a pivot table to summarize certain fields. A sum of all items from a state, for example. In the pivot table I would just put the state criteria to the left and the "count of state" in the main section of the table. How do I do something similar in Access?

  2. #2
    5 Star Lounger
    Join Date
    Feb 2001
    Location
    Youngstown, Ohio, USA
    Posts
    705
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: SUM of items in a table

    I would use a query. For the simplest solution, you could build a query with the state as the first field, then your desired "other" field/s next. Using totals, use "Group By" for the state, and "Count" for your other fields.

    If this isn't exactly what you need, the Crosstab Query Wizard is good at building similar types of tables.

Posting Permissions

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