simple Switch function question

[billybeer]

I have a report that I want to use the Switch function in one of the fields. I have a query that will return the criminal statute number for a crime (i.e. 750/82) I want to switch that to the title of the crime (Domestic violence). My issue is that there are hundreds of statute numbers and I only want to switch the most 40 or so most used statutes. When I use the switch function it works with the statutes I put in but returns a blank for the ones I haven't put into the function. Is there a way to switch from number to title on the ones I have done and simply return the statute number for the ones I haven't included in the switch function?

[ranman256]

you should use lookup tables for this ,instead of hard coded switch function.
join the data table to the code table, then perform an update.

[billybeer]

Thanks for the direction.

[June7]

ranman, what do you mean by 'perform an update'? There is no reason to save the crime title into data table. Just build query that links tables. Then expression in query or textbox:

Nz([CrimeTitle], [Statute])

How many hundreds? Would it be worthwhile to enter the title for all codes?

Now the decision to make is whether to save the statute code which is a text value or an autonumber ID key from the lookup table.