IF anyone could help me try to trouble my formula below, I would greatly appreciate it:
If trim({cpfind.RECNO}) = "2" then "Pregant Woman"
else if trim({cpfind.RECNO}) = "3" then "Breastfeeding Woman"
else if trim({cpfind.RECNO}) = "4" then "Postpartum Woman"
else "bogus"
This is the formula that I am trying to use to set my text. The cpfind.recno is a string field that holds 10 characters. I know that I have all 3 set in my database and I continue to get the bogus message.
Any help, I would appreciate it!!
Thanks
If trim({cpfind.RECNO}) = "2" then "Pregant Woman"
else if trim({cpfind.RECNO}) = "3" then "Breastfeeding Woman"
else if trim({cpfind.RECNO}) = "4" then "Postpartum Woman"
else "bogus"
This is the formula that I am trying to use to set my text. The cpfind.recno is a string field that holds 10 characters. I know that I have all 3 set in my database and I continue to get the bogus message.
Any help, I would appreciate it!!
Thanks