switch or chose function?

  • Thread starter Thread starter mo
  • Start date Start date
M

mo

I have a bunch of hospital codes that look like this:

L, S, U, R, G etc.

In a query I need to transform these into

Llan, Sing, UHW, etc etc.

Which function should I use to do this and how does it work?

Thanks for any help.

Mo
 
mo said:
I have a bunch of hospital codes that look like this:

L, S, U, R, G etc.

In a query I need to transform these into

Llan, Sing, UHW, etc etc.

Which function should I use to do this and how does it work?

Thanks for any help.

Mo
Click to expand...
Store the values in a table and link that. Your new table would look like

abbr expandedName
L Llan
S Sing
U UHW
R etc
G etc.
;-)

In the query you can draw a line between the tables, pointing out the
fields that should match. Put the expandedName in the field list to show.
 
Back
Top