Change field in linked table

[wtrimble]

My co-worker has an excel file that needs to be linked to my database. In one column he has "conditional formatting" to make value 2 to a check mark, 1 to a red "X" and 0 as (!). So when he puts in 2, it'll show a check mark etc.

The problem is that I need to show this information in a query-subform but instead of the 0's, 1's, and 2's that'll be shown on that field, I need to show "yes" for 2 "no" for 1 and "Unknown" for 0. But I'm not sure on how to do it!

I was trying to create a query that would make a new field perhaps that would display yes, no and unknown, but I couldn't figure out how to do it.

Any ideas would be greatly appreciated.

P.s. Also my co-worker doesn't want to add any fields in his excel table

Thanks

 

[boblarson]

You can create a new field in your query and use SWITCH:

YourNewFieldNameHere:Switch([YourOldFieldName]=2,"Yes",[YourOldFieldName]=1, "No", [YourOldFieldName]="Unknown")

Make sure the old field name is inside square brackets when you do this too.

 

[wtrimble]

That should do it. Thanks Bob