Results 1 to 4 of 4
  1. #1
    jlclark4 is offline Competent Performer
    Windows XP Access 2003
    Join Date
    Dec 2010
    Location
    North Carolina
    Posts
    155

    Smile Adding Fields

    Hey



    I am trying to add up points possible verus points earned in a query. I have a query set up that calculates the points possible for each tab in my form/table. Below is an example of the feilds I am trying to add together.

    I have a table with feilds 2a, comment (2a), D2a, Q2a, 2b, comment (2b), Q2b, 2c, comment (2c), Q2c, etc.

    The beginning number represents what tab the questions were in (this form is used for quality and has questions and answer on it and certain questions are weighted different)

    I tried to use a Expression in the Query
    Quality: [Q2a]+[Q2b]... but it adds all the rows and fields together which I do not want it to do. I only want it to add the points earned across that row.

    Any Ideas?

  2. #2
    mbar is offline Novice
    Windows XP Access 2003
    Join Date
    Apr 2011
    Posts
    12
    I'm not an expert but I'll attempt to help...

    it should only add the fields for each record. are you grouping these records and is that field which contains the expression set to "sum"?

  3. #3
    jlclark4 is offline Competent Performer
    Windows XP Access 2003
    Join Date
    Dec 2010
    Location
    North Carolina
    Posts
    155
    I tried that and it gives a number that does not make since. The returned number should be no more then that listed in the QualityPoints Field. See the attached screenshots

  4. #4
    kennejd is offline Competent Performer
    Windows XP Access 2007
    Join Date
    Mar 2011
    Posts
    188
    I can only see part of the query so it's difficult to tell what's wrong. It could be a matter of changing some grouping.....or possibly your table isn't set up right.

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

Similar Threads

  1. Adding 2 fields together
    By Craig Spencer in forum Access
    Replies: 2
    Last Post: 04-08-2011, 02:10 PM
  2. Replies: 5
    Last Post: 03-23-2011, 02:28 PM
  3. Adding of Fields in Different records
    By pcliaros in forum Queries
    Replies: 1
    Last Post: 03-17-2010, 02:31 AM
  4. Replies: 4
    Last Post: 09-21-2009, 01:51 PM
  5. datasheet view adding fields drop-down box
    By techexpressinc in forum Access
    Replies: 2
    Last Post: 09-09-2009, 05:35 AM

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