IIF Function in a form?

[cap.zadi]

Dears,



Hope you all of are fine and sorry to bother you regarding my questions here.

i would like to ask today about the IIF function which i want to put in a form like wise.

I have the follwoing 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.

hope to get the reply.

thanks

zee

[alansidman]

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.

Alan

[cap.zadi]

thanks man. it works nice.

[cap.zadi]

Hello Sir there.

The above formula is working fantastic but the results are not saved in table and cant be seen in reports also. just it can be print out from the form. plz advise.

[alansidman]

Calculations should not be saved in tables. That is bad database practice. If you wish to see the results in a report, then make a query and put the calculation in a new field and then use the query as your record source for your report instead of your table.

In the QBE, in a new column, type Leakage: =iif([Reading]<([Stnd Values]-[Stnd Values]*.05) or [Reading]>([Stnd Values]+[Stnd Values]*.05),"Leakage Found","No Leakage Found")
and then do the same for the Results.

Alan

[cap.zadi]

Ok sir, i do agree with u and it looks nice way. but i need to print this form after finish the transaction bcz its a laboratory database. So how to make this form which also part of master table and query which shows results on form?

thanks

[cap.zadi]

sorry for misunderstanding. in form print it show the results and also print. so i already set those fields through a query and it appears now in report.

thanks

zee

[alansidman]

Happy to hear that you solved it.

Alan