Access Access Reporting


Joined
Jul 22, 2017
Messages
1
Reaction score
0
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.
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top