Total of columns in Query

B

B Earl

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?
 
R

Rick B

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
 
Top