IIF condition

[Gerald]

dear all,

need to check a condition if less than 2 months 'rejected' or approved
and if more than 8 yeas 'rejected' or approved

done above as below

agecal = IIf([age] >= 0.16, "OK, NOT BELOW 2 MONTHS", "BELOW 1 MONTHS NOT
ALLOWED")
agecal1 = IIf([age] <= 8, "OK, NOT ABOVE 8 YRS", "ABOVE 8 YRS NOT ALLOWED")

agecal1 works fine, however agecal does work only for 12 months not for
2months

e.g. if a age is 0years and 8weeks or less it should say rejected but if 0
years and 9 weeks should say approved

is it possible

thanks

 

[David W]

How are you collecting the age, is it one textbox or two?

 

[Gerald]

2 textboxes... however ideally the way I need was one textbox showing 4
conditions

but no luck, so had 2 textboxes

thanks

How are you collecting the age, is it one textbox or two?

dear all,

need to check a condition if less than 2 months 'rejected' or approved
and if more than 8 yeas 'rejected' or approved

done above as below

agecal = IIf([age] >= 0.16, "OK, NOT BELOW 2 MONTHS", "BELOW 1 MONTHS NOT
ALLOWED")
agecal1 = IIf([age] <= 8, "OK, NOT ABOVE 8 YRS", "ABOVE 8 YRS NOT
ALLOWED")

agecal1 works fine, however agecal does work only for 12 months not for
2months

e.g. if a age is 0years and 8weeks or less it should say rejected but if 0
years and 9 weeks should say approved

is it possible

thanks

 

[Gerald]

age is calculated in one text box but the conditions i.e the tex e.g"OK, NOT
BELOW 2 MONTHS" shown in 2 textboxes

How are you collecting the age, is it one textbox or two?

dear all,

need to check a condition if less than 2 months 'rejected' or approved
and if more than 8 yeas 'rejected' or approved

done above as below

agecal = IIf([age] >= 0.16, "OK, NOT BELOW 2 MONTHS", "BELOW 1 MONTHS NOT
ALLOWED")
agecal1 = IIf([age] <= 8, "OK, NOT ABOVE 8 YRS", "ABOVE 8 YRS NOT
ALLOWED")

agecal1 works fine, however agecal does work only for 12 months not for
2months

e.g. if a age is 0years and 8weeks or less it should say rejected but if 0
years and 9 weeks should say approved

is it possible

thanks