Test if a value exist or not

[nirvana0]

Hi everyone,

Well , i have a table Terminal with 2 fields( A and B).=> I want to make a querry (UPDATE) to test if the value starting from line 2 is present (we check both fields A and B) => if the value is present in A , all the similar values moves to A(if it is already in A=>it remains there else it moves to A) , same thing for B.



thanks for you re help.

[ranman256]

Is this it?

select Iif(isNull([fieldA]),"absent","present") as F1, Iif(isNull([fieldB]),"absent","present") as F2 from TERMINAL

[nirvana0]

No , well ill explain more.

In ACCESS, i want an UPDATE request that can test from the FIRST SIMILAR VALUE (there is more than100 values) => for exemple: if first value = X is in A then all the other X that are in the table (even in field A or B) have to be IN FIELD A. and same for the other.
I put the file in attachements pieces.
Thank you.

[nirvana0]

I just want a request so i can make it. I cant find :s