This is driving me crazy, seems lik 1

[chrisp909]

This is driving me crazy, seems like it should be simple BUT...

If the students don't have a middle intitial for this formula only the students with middle initials diplay. So I added a condition that does exactly the same thing. If I make {AdmittedStudent.AdmittedStudent_Middle_Initial} 'equal to' or 'less than' zero I still only display the students with middle initials but the middle initials don't display.

if {AdmittedStudent.AdmittedStudent_Middle_Initial} > '0' then
{AdmittedStudent.AdmittedStudent_Last_Name} + ", " + {AdmittedStudent.AdmittedStudent_First_Name} + " " + {AdmittedStudent.AdmittedStudent_Middle_Initial}
else
{AdmittedStudent.AdmittedStudent_Last_Name} + ", " + {AdmittedStudent.AdmittedStudent_First_Name}

 

[dgillz]

try this:
if Isnull({AdmittedStudent.AdmittedStudent_Middle_Initial}) then {AdmittedStudent.AdmittedStudent_Last_Name} + ", " + {AdmittedStudent.AdmittedStudent_First_Name}

else

{AdmittedStudent.AdmittedStudent_Last_Name} + ", " + {AdmittedStudent.AdmittedStudent_First_Name} + " " + {AdmittedStudent.AdmittedStudent_Middle_Initial}
Software Support for Sage Mas90, Macola, Crystal Reports and Goldmine

 

[csm2]

You might want to "TRIM" the fields in your concatenation, especially on the Middle Initial field.

 

[chrisp909]

dgillz,

you're the man!