Total of columns in Query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a query that I would like to have a total of some of the columns in
this query if they are not null. The ones that have text in them. Is there a
way to do this?
 
Add a new column to the end of your query and put something like...


SomeNewFieldName: [SomeItem1] + [SomeItem2] + [SomeItem3]

Give us specifics if you need more details.

Rick B
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Counting multiple memberships 1
Access Query problem 1
Query with multiple results 1
totaling a column then substracting them 1
Modify Query on the fly 7
Query to display highest totals 1
Access stripping decimal places in query 1
Total certain records 1

Back
Top