Hi there, I have create a query for lab analysis result. The 1st column name is the Value Chloramphenicol. This column were use to key in the result get from the analysis done. The next column name Result that will showing the result of the analysis.
The standard to use is when the value chloramphenicol entered >= 0.300 the column Result will change to POSITIVE and when the user enterd value < 0.300 (0.999) the column Result will change to NEGATIVE. I have use the expression like below: Result: IIf([Value Chloramphenicol]>=0.3,"POSITIVE","NEGATIVE") However some of the analysis could't detect any value and the Result column should be appear as NOT DETECT when user key in ND or 0.000 in the column Value Chloramphenicol. Another case when the certain did't do analysis sample user will entered NA and the Result column should appear NOT ANALYSE. Anyone can help me to get the expression for the above case that i can use for the query. Thanks. Iswandy Abdul Rahman [EMAIL PROTECTED]
