Criteria in Query

[Dina01]

Hello,

I created a query that has 4 fields, one of the fields name is "code" the data possible in code a are numbers 1,2,3,4,5 and I want the fields to show the following data.

if the code is equal to 1 then "assigned"
if the code is equal to 2 then "pause"
if the code is equal to 3 then "not assigned"
if the code is equal to 4 then "waiting pause"
if the code is equal to 5 then "unknown"


Thanks
Dina

 

[Jack Cowley]

Create a lookup table based on the code and 'description' and add that to your query and you should be good to go..

hth,
Jack