Condition query without using IIF?

[trebor3900]

I am trying to force a query to select all fields with a zero value but to carry out a different query if the value is more than zero.

I have tried with IIF statements in the criteria but without success.
ie

IIf ( [tblClothing]![ChestMax] = 0 , [tblClothing]![ChestMax] , [tblOfficers]![ChestSize] Between [tblClothing]![ChestMin] And [tblClothing]![ChestMax] )

As they seem to adversly effect other criteria in the same query

 

[ByteMyzer]

Perhaps if you were to post the ENTIRE Sql of your query here, it would be easier to help you.