Syntax issue with query field in query designer

How should this read?

BuyerCommPending: Sum([HH Sale $ Commission] If [Pending]=True)
SteveL13Asked:
Who is Participating?
 
Rey Obrero (Capricorn1)Connect With a Mentor Commented:
try this, if [pending] is true, get the sum of field [HH Sale $ Commission]


BuyerCommPending: Sum(IIf([Pending]=True,[HH Sale $ Commission],0))
0
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.