Changing the field format

J

jp77

I am new Access user so this might be a simple question. I have a table in my
query that lists the answers of a yes/no question as "Y" or "N". How would I
change the format of that field in my query so that the output in that column
is a "Yes" or "No"?

Thanks for the help.
 
F

fredg

I am new Access user so this might be a simple question. I have a table in my
query that lists the answers of a yes/no question as "Y" or "N". How would I
change the format of that field in my query so that the output in that column
is a "Yes" or "No"?

Thanks for the help.
Click to expand...

The field is a Text datatype?


What if there is nothing in the field?
Exp:IIf([FieldName]="Y","Yes",IIf([Fieldname]="N","No","Neither"))

If the field always contains a "Y" or "N", then
Exp:IIf([FieldName]="Y","Yes","No")
 
J

jp77

It worked. Thanks a lot!

fredg said:
I am new Access user so this might be a simple question. I have a table in my
query that lists the answers of a yes/no question as "Y" or "N". How would I
change the format of that field in my query so that the output in that column
is a "Yes" or "No"?

Thanks for the help.
Click to expand...

The field is a Text datatype?


What if there is nothing in the field?
Exp:IIf([FieldName]="Y","Yes",IIf([Fieldname]="N","No","Neither"))

If the field always contains a "Y" or "N", then
Exp:IIf([FieldName]="Y","Yes","No")
Click to expand...
 
Top