Hi anf thanks for any help you can offer
I have subreport that has the results of laboratory analyses. Field name is [Result] this is a text field as it may contain a number (e.g. 200, 1.3, <3 or >1,000) or text (e.g. No Growth or Not Detected).
My problem only exists when I am evaluatng the [Result] field when it has a '< or '>' sign beforethe number. I also have on the report the acceptale limit, if it applies in a field called [SNRV]
'On Format' forthe Details section coding is my dilema, I need to put ticks or crosses at the start of the line, that is, before the [Result] if it is a pass or fail
I have no trouble doing that when I have a number as the result.
But let's say the [Result] is <1 and the aceptable limit is <3 that is, the [SNRV] is 3. In this case I need to test if the characters after the '<' sign are less than the [SNRV] so I can mark tis as a pass.
Even worse, when the [Result] is <10 and the acceptable limit is <3. In this case I need to determine that I can not evaluate the result and not put a tick or cross against this result.
I tried
If Me![Result] like "<*) then ' this line works fine
If Mid(Me![Result],2) <= Me![SNRV] then ' -->>>>But this doesn't work
Me![Tick].Visible = True
Me![Cross].Visible = False
Else
Me![Tick].Visible = False
Me![Cross].Visible = False
End If
End If
All my other programing regarding'<' and '>' results can be done once I determine how to evaluate the number in a field after a "<' or '>' sign and compare it to a numeric field result.
Any ideas you gurus of Access programming? Please help I have run out of ideas.
Cheers
Glen - Simple Scientist from Australia