Switch between data in Access

[JackONeill]

Hi,

I d like to made a query on two columns.

A: 1,2,3,4,5,6,7,0,0,0,0
B: 0,0,0,0,0,0,0,3,4,5,6

What i want to do is when in column A there is a "0" it take the value of column B

So the Result is :

C: 1,2,3,4,5,6,7,3,4,5,6

Any idea to build the funcion in Ms Acces ?

 

[dhookom]

In your example, you could create a query:
SELECT A+B as C
FROM tblA

Duane
MS Access MVP
Find out how to get great answers faq219-2884.