Help with calculations in a query

C

clarked

Hello...I have performed a calcualtion [Field1]/11
but I only want the calculation to be performed if another field has a "Yes"
How do I set this in a query? It is a bit like an IF function in a
spreadsheet.
 
D

Dennis

IIF([OtherField]="Yes",[Field1]/11,0)

The zero at the end can be anything you want it to be if the otherfield is
not Yes
 
Top