trying to make a new table from an old one

[lipin]

I have a table with 5 fields. I am trying to make a new table with a make table query. In the old table there is a field called 'code'. We are changing coding structure and reason codes so I am trying a calculated field called 'new codes' in the new table. What I would like is to somewhere in the query say that if code is "MT" or "NT" or "FC" in the field code then it will be a "MT" in the calculated 'new codes' field.

So my question is how and where do I tell it to evaluate the old code field?

 

[Newman]

You should not put a calculated field in a table. Create it in your queries instead.

 

[Jon K]

Type this in the Field: cell of a new column in the query grid:-

New Code: IIf(

 In ("MT","NT","FC"), "MT", Null)