Results 1 to 2 of 2
  1. 03-03-2010, 07:05 PM #1
    wconan
    wconan is offline Novice
    Windows 7 Access 2003
    Join Date
    Mar 2010
    Posts
    3

    Sum Row

    I'm new to access, so i don't know alot



    I like to know if you can sum row?

    I have

    Name A B C
    aaaaa 2 3 4
    bbbbb 2 3 4
    cccccc 2 3 4


    And I want

    Name A B C
    aaaaa 2 3 4
    bbbbb 2 3 4
    cccccc 2 3 4
    Total 6 9 12


    what do I write in SQL?
    Reply With Quote Reply With Quote
  2. 03-03-2010, 07:27 PM #2
    pbaldy's Avatar
    pbaldy
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,641
    In design view:

    NewFieldName: A + B + C
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com
    Reply With Quote Reply With Quote
Please reply to this thread with any new information or opinions.
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules

Other Forums: Microsoft Office Forums