Pick the column with data in it ??

[ccondran08]

i have a query with 4 columns of data, in most cases 3 of the columns will have the number zero in there and one column will have one word in there. I'm looking for some 'IIF' statement help to formulate a query that will look at each column to see which column has the word in it and then return that word as the result. Any help would be greatly appreciated :banghead:

 

[arnelgp]

Text: iif(nz([column1],0) & "" = "0","",[column1]) & iif(nz([column2],0) & "" = "0","",[column2]) & iif(nz([column3],0) & "" = "0","",[column3]) & iif(nz([column4],0) & "" = "0","",[column4])

 

[ccondran08]

Excellent, works perfectly. Thanks.