New Field Query

M_Mike

Registered User.
Local time
Today, 19:57
Joined
Aug 10, 2005
Messages
31
Can anyone help me create a query to do the following:

I have to fields in a table and want to create a thrid field depending on the values in the other two.

What I need to do is select all the values from column2 and all the values from column1 when there is no coresponding value in column2.

eg.
Column1 Column2 Column3
1 158 158
0 45 45
34 0 34

Any help would be appreciated.
 
Column 3: IIf([Column 2]=0, [Column 1], [Column 2])

^
 

Users who are viewing this thread

Back
Top Bottom