Access Access Reporting

[Dana Clyde]

I am looking for help, I have the following language plugged into an MS Access report

=IIf([Test_Result]>"3999",">4000") & IIf([Test_Result])<"4000", [Test_Result]) & " pg/ml"

For some reason this language works 90% of the time. I cannot figure out what the problem is. Anyone see any obvious omission I have overlooked?

For example I have Test Result field = 560, but the language will return the canned >4000 .
With results of 560 I expect the language to return 560, but it is returning the >4000 language.

 

[Gus Mickus]

Try; =IIf([Test_Result]>"3999",">4000"),([Test_Result])