Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2003
    Posts
    5

    Unanswered: summing a column

    Another dumb question from Peter....

    How do I sum a column in Access? Do I need to run a query on my data to do this? And, if so, then what? I told you it would be a dumb question!

  2. #2
    Join Date
    Sep 2003
    Location
    T.O.
    Posts
    326
    There are no dumb questions, just dumb answers.

    Create your query based on your table.
    Pull down only the column you are interested in Summing.
    From the View Menu, choose Totals
    Your QBE grid will change
    From the Total: row, choose Sum
    Run your query.

    Mike.
    All code ADO/ADOX unless otherwise specified.
    Mike.

  3. #3
    Join Date
    Aug 2003
    Posts
    5
    Thanks, Homer.

Posting Permissions

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