Iif statement with multiple criteria

[coach32]

In my select query I have two columns of data - Priority - Complexity. I want to be able to populate a new field with, for eg: 'P1' if 'Priority' = 3-Medium and 'Complexity' = Medium, or a 'P2' if I have 2-Low and High. Could someone please show me what the IIf statement should/could look like? Thank-you in advance for your assistance.

[cap.zadi]

hello man, please read this one which is working nicely and get into ur data.

I have the following fields;

Sample No, Reading, Leakage, Stnd Values, Results,
1 0.048 Not Found 0.07 Passed


suppose if there is stnd values set for a test is 0.07 and have +5% allowance so when data is entered in the "Reading" field it should filled up the "Leakage" and "result" fields, there was "no leakage found" and "faild or passed" vice versa.


In your Leakage Textbox, place this calculation:

=iif([Reading]<([Stnd Values]-[Stnd Values]*.05) or [Reading]>([Stnd Values]+[Stnd Values]*.05),"Leakage Found","No Leakage Found")

and a similar formula for the results field.

regards.

zee