Guys
Please tell me how to write a query to SUM some text fields.
for example i have this table:
I need this:
there is a sample db for your kind help
Text sum.accdb
Guys
Please tell me how to write a query to SUM some text fields.
for example i have this table:
I need this:
there is a sample db for your kind help
Text sum.accdb
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).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?
Maybe this will help: https://stackoverflow.com/questions/...ield-in-access
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?)
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, Regardsto 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.