Another expression in a query

Using query designer I need code to:

Sum the totals of [NumberOfHours] where PublicActivityCode] = "GT" or "ST".

It needs to be an expression because I have more of these types of fields to add.

An expert already helped me wit another code which worked for that one.  It was:

TouringCount: Sum(Abs([PublicActivityCode]="GT" Or [PublicActivityCode]="ST"))

So it has to be something like: (but the syntax is wrong)

TotalHours: Sum(Abs(NumberOfHours] WHERE ([PublicActivityCode]="GT" Or [PublicActivityCode]="ST"))

Who is Participating?
chaauConnect With a Mentor Commented:
I think, something like this will work:
TotalHours: Sum(iif([PublicActivityCode]="GT" Or [PublicActivityCode]="ST", [NumberOfHours], 0))

Open in new window

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.