How can I use a query to compare single letter in table to the corresponding word?

[jnrussell]

I thought this would be easy, but I've been trying various things and can't figure it out. In of of my tables there is a column called "Type". In the Type field there are entries like "F", "I", "R", etc. On a report I want those entries to display the corresponding word that matches it: "F" would be "FISH", "I" would be "INVERTEBRATES", "R" would be "REPTILES", etc.



How can I create a query, or create an expression in the main query for the report that will make this conversion?

[June7]

Options:

1. If there are only the 3 Types, use an expression:
Switch([Type]="F",FISH", [Type]="I","INVERTEBRATES", [Type]="R","REPTILES")

2. If you have more than 3 Types or want greater flexibility to add more, create a table of the Type codes and descriptors, include this table in query by joining on the common Type code fields.

Consider saving the full text descriptor instead of just the single letter code. Then no need to join tables in query. Can still use a table as source for combobox.

[jnrussell]

I knew it was simple! I've actually used method 2 many times before. Don't know why I couldn't think of it in this case. However, I'm glad I asked because I wasn't familiar with method 1. I like it and am going to try it here. Thank you so much.

[June7]

Ooops! I should have used Switch instead of Choose. I edited the post.

Can be used with more than 3 elements.

[jnrussell]

Thanks. You posted the correction before I had time to try it out, so it all worked out. I used Switch and it worked perfectly. Thanks