Results 1 to 2 of 2
  1. #1
    4 Star Lounger
    Join Date
    Jan 2001
    Location
    Richmond, Virginia, USA
    Posts
    416
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Adding a column in a query (2000 SR1)

    I don't know if this is possible, but is there a way to insert a column that can add the sum of another column?

    Here's an example of what I want to do, I want to add the numbers in the second column and give me a grand total of the 3 things listed for my name in another column.

    Becky____5
    Becky____5
    Becky____8

    =Becky_______18

    Can I do this in Access, or do I have to go to Excel?

    Thanks, and I hope this makes sense!
    Becky

  2. #2
    2 Star Lounger
    Join Date
    May 2001
    Location
    Wichita, Kansas, USA
    Posts
    177
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Adding a column in a query (2000 SR1)

    You can use the COUNT expression in the next blank field of your query to create the third colum with the sums (right click on the blank field and choose "build" to open the expression builder to help you)

Posting Permissions

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