Results 1 to 7 of 7
  1. 03-01-2017, 10:36 PM #1
    dina1808
    dina1808 is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Mar 2017
    Posts
    9

    Totalling columnwise


    I had created table as below, would like to get total column-wise. Pls help
    So. No. Name. Maths Eng. Sci. Total
    1. A 10 20 30

    I'm looking to total maths, sciand English in total field....
    Reply With Quote Reply With Quote
  2. 03-02-2017, 12:39 AM #2
    Bob Fitz's Avatar
    Bob Fitz
    Bob Fitz is offline Access Developer
    Windows 7 32bit Access 2013
    Join Date
    May 2011
    Location
    Essex UK
    Posts
    3,614
    Use a calculated field in a query. Something like Tot:[Maths] + [Eng] + [Sci]

    EDIT
    "Name" is a reserverd word in access and should not be used to name an object
    Last edited by Bob Fitz; 03-02-2017 at 12:43 AM. Reason: More onfo
    If this helped, please click the star at the bottom left of this posting and add to my reputation . Many thanks.
    Bob Fitzpatrick
    Reply With Quote Reply With Quote
  3. 03-02-2017, 12:48 AM #3
    dina1808
    dina1808 is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Mar 2017
    Posts
    9
    Thanks Bob, if possible could you plz list the steps I have to perform... Thanks
    Reply With Quote Reply With Quote
  4. 03-02-2017, 01:31 AM #4
    Bob Fitz's Avatar
    Bob Fitz
    Bob Fitz is offline Access Developer
    Windows 7 32bit Access 2013
    Join Date
    May 2011
    Location
    Essex UK
    Posts
    3,614
    Open a new query in design view
    Add you table to the query
    Add your fields to the grid
    Copy and paste the calculated expression I posted earlier in to the the first line of a blank column in the grid
    If this helped, please click the star at the bottom left of this posting and add to my reputation . Many thanks.
    Bob Fitzpatrick
    Reply With Quote Reply With Quote
  5. 03-02-2017, 01:48 AM #5
    dina1808
    dina1808 is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Mar 2017
    Posts
    9
    Got it.. Thanks a lot!!!!

    Just to know, is there any possible to do the same in table itself rather than query...
    Reply With Quote Reply With Quote
  6. 03-02-2017, 01:53 AM #6
    Bob Fitz's Avatar
    Bob Fitz
    Bob Fitz is offline Access Developer
    Windows 7 32bit Access 2013
    Join Date
    May 2011
    Location
    Essex UK
    Posts
    3,614
    Quite honestly I don't know, but I wouldn't even if I could.
    If this helped, please click the star at the bottom left of this posting and add to my reputation . Many thanks.
    Bob Fitzpatrick
    Reply With Quote Reply With Quote
  7. 03-02-2017, 02:17 AM #7
    dina1808
    dina1808 is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Mar 2017
    Posts
    9
    NP.. You are great!!!
    Reply With Quote Reply With Quote
Please reply to this thread with any new information or opinions.
« Previous Thread | Next Thread »

Similar Threads

  1. Totalling question
    By Frankf in forum Access
    Replies: 3
    Last Post: 12-18-2016, 04:38 PM
  2. looping through recordset (columnwise)
    By pradeep.sands in forum Queries
    Replies: 1
    Last Post: 06-27-2013, 09:46 AM
  3. Need help with totalling a field in Subform
    By Astron2012 in forum Forms
    Replies: 1
    Last Post: 05-18-2012, 04:49 AM
  4. Totalling
    By cbrsix in forum Reports
    Replies: 17
    Last Post: 11-17-2011, 02:54 PM
  5. Totalling Time Values
    By l3111 in forum Access
    Replies: 2
    Last Post: 07-16-2011, 08:05 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
  •  

Forum Rules

Other Forums: Microsoft Office Forums