APPEND Query with replaces

  • Thread starter Thread starter Akshay Bakhai
  • Start date Start date
A

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.
 
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
 
Back
Top