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
 
Back
Top