IIF condition

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
2 textboxes... however ideally the way I need was one textbox showing 4
conditions

but no luck, so had 2 textboxes

thanks



David W said:
How are you collecting the age, is it one textbox or two?


Gerald said:
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
Click to expand...
Click to expand...
 
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
David W said:
How are you collecting the age, is it one textbox or two?


Gerald said:
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
Click to expand...
Click to expand...
 
Back
Top