Results 1 to 7 of 7
  1. #1
    ArvinFx is offline Novice
    Windows 7 64bit Access 2013 64bit
    Join Date
    Feb 2017
    Posts
    15

    Sum Text in group query?

    Guys



    Please tell me how to write a query to SUM some text fields.


    for example i have this table:

    Click image for larger version. 

Name:	Table1.jpg 
Views:	14 
Size:	4.5 KB 
ID:	29493

    I need this:

    Click image for larger version. 

Name:	My Desier.jpg 
Views:	14 
Size:	7.4 KB 
ID:	29491

    there is a sample db for your kind help

    Text sum.accdb

  2. #2
    Join Date
    Jun 2015
    Location
    Wales. Land of the sheep.
    Posts
    1,228
    you're also asking to concatenate the text strings? On the Query design tab there is a "Totals" button where you can group (it will be group by default). you can change where it says group to "Sum" and it will add up whatever is grouped. Are you wanting to sum every item in your database or is there a criteria for the items you want?

  3. #3
    ArvinFx is offline Novice
    Windows 7 64bit Access 2013 64bit
    Join Date
    Feb 2017
    Posts
    15
    Quote Originally Posted by Homegrownandy View Post
    you're also asking to concatenate the text strings? On the Query design tab there is a "Totals" button where you can group (it will be group by default). you can change where it says group to "Sum" and it will add up whatever is grouped. Are you wanting to sum every item in your database or is there a criteria for the items you want?
    Hi, I need to concatenate all items in my query ( Add numbers and concatenate texts).

  4. #4
    aytee111 is offline Competent At Times
    Windows 10 Access 2013 64bit
    Join Date
    Nov 2011
    Location
    Nomad
    Posts
    3,936

  5. #5
    Join Date
    Jun 2015
    Location
    Wales. Land of the sheep.
    Posts
    1,228
    Sadley the code to concatenate isn't available at the moment. How do you want this info displayed? on a form on screen or a report? (pdf?)

  6. #6
    Join Date
    Jun 2015
    Location
    Wales. Land of the sheep.
    Posts
    1,228
    to follow up aytees post :

    https://web.archive.org/web/20160307...nc-concat.html

    This is a shot of the page before it was taken down.

  7. #7
    ArvinFx is offline Novice
    Windows 7 64bit Access 2013 64bit
    Join Date
    Feb 2017
    Posts
    15
    Quote Originally Posted by Homegrownandy View Post
    to follow up aytees post :

    https://web.archive.org/web/20160307...nc-concat.html

    This is a shot of the page before it was taken down.
    It works, Regards

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

Similar Threads

  1. Replies: 6
    Last Post: 06-09-2015, 09:51 AM
  2. Group duplicate text fields as one?
    By jset818 in forum Queries
    Replies: 13
    Last Post: 10-24-2014, 01:05 PM
  3. Option Group To Return Text Instead of a Value
    By justair07 in forum Access
    Replies: 3
    Last Post: 08-21-2013, 02:31 PM
  4. Replies: 2
    Last Post: 06-21-2012, 07:40 PM
  5. Group text field
    By DanielY8 in forum Queries
    Replies: 4
    Last Post: 10-28-2011, 12:38 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