APPEND Query with replaces

[Akshay Bakhai]

Here goes-

I am appending records from table A to table B. Let's say
field X of table A is appended to field P of table B.

I wanted to know if there was a means to perform data
substition in the same query; thus if field X had value 1
then it gets changed to value "j" in field P (for example).

If this is possible, could someone please explain how it
can be achieved?

If it cannot be done in the same query then any other
means could also be interesting to know.

br

akshay.

 

[mark grizzle]

Create a new column in the append query, and appeand it
to Field P.

CalcX: Iif(FieldX = 1,"J",FieldX))

This means: if field x = 1 then append J else append
field x