I can't output text from an if statement when many programs are in one field
Posted by Kyle on August 20, 2001 3:21 PM
I am working on a reference template for the company I work for, and I need one of the fields to output a letter according to the number entered in another field. I can get this to work if I only have one if statement in a field, so I know I've got the format correct, and I am using the exact same format for other fields that return a simple number, which have more IF statements in it that the field I have this problem with. Currently, I use the CHAR(##) function, with CHAR(65) being the numerical representation for A, and so on. I have also tried the TEXT function, but to no avail. I would deeply apprectiate any suggestions.