Hi all,
I think my problem is simple for this forum.
I have a form that users insert the group of criteria, as
Form Criteria (example of a document)
Cod Criteria = AAA
(text) fieldoperatorvaluemin = “>”
(number) valuemin = 200.000
(text) fieldoperatorvaluemax = “<”
(number) valuemax = 500.000
In other form I have a lotus script that verify values of current form and get the right criteria for this document.
But my problem is construct a condition using “If” getting operators of Criteria Form and numbers of current form.
as below
if valueActual & fieldoperatorvaluemin & valuemin And valueActual & fieldoperatorvaluemax & valuemax Then
(this line has to represent===> if 230.000 > 200.000 And 230.000 < 500.000 then)
230.000 = actual Value
“>”= operator of criteria form
200.000 = value of criteria form
“<” = operator of criteria form
500.000 = value of criteria form
How can I do it?
Can you help me?
Thanks…