equal to

[vj135]

hi,

I have a column which is denoted by F in the header and M in the header.

i want to create a formula that will show Female and Male instead of F and M

Thanks
vj135

 

[synapsevampire]

Try using a formula of:

if {table.field} = "F" then
"Female"
else
if {table.field} = "M" then
"Male"
else
"Unknown"

-k

 

[vj135]

do i create this under Selection Formulas/record selection (i already have a formuala in this section)

the other option is to under formula fields by selecting new -- doing this does not seem to help

pl advise

thanks

 

[synapsevampire]

Yes, under formula fields, adn then use that formula field as your column instead of the table.field.

-k

 

[vj135]

Your last reply helped.

THANKS VERY VERY much

vj