Results 1 to 2 of 2
  1. #1
    Arsalan is offline Novice
    Windows XP Access 2007
    Join Date
    Jan 2013
    Posts
    11

    Sum Of Rows

    I have three column in table named Col1 : Col2 : Col3. I want sum of Col1 and Col2 in Col3. Is it possible in Access 2007?

  2. #2
    JoeM is offline VIP
    Windows XP Access 2007
    Join Date
    Jun 2012
    Posts
    3,904
    You can do that in a calculated field (expression) in a query, i.e.
    MySum: [Col1] + [Col2] + [Col3]

    If you want to read up on it more, Access's built-in help files has information on creating calculated fields (expressions) in queries. Any beginner Access book will have it to.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. combining rows.. again
    By jerryb in forum Access
    Replies: 16
    Last Post: 05-03-2012, 08:34 PM
  2. Deleting rows
    By ads8525 in forum Access
    Replies: 13
    Last Post: 02-10-2012, 08:52 AM
  3. Replies: 0
    Last Post: 02-09-2012, 05:43 PM
  4. Replies: 2
    Last Post: 08-28-2011, 06:06 AM
  5. Combining rows
    By Bing in forum Queries
    Replies: 1
    Last Post: 06-09-2011, 12:54 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums