Combining two columns into one in access

[Janae]

Hi,

I am trying to combine my two columns of data into one column in access. I have one column that has all rows populated (col1) , and I have a second column that only is occasionally filled (col2), and is generally blank. Both columns contain different information. I want one column where if col2 is populated, it takes that value, but if col2 is blank, it shows the value from col1. How can I do this in access. In excel I would write a formula like so "if(col1="",col2,col1). I tried creating a query in access to do this using the iif function. Expression looked as follows:

Expr1: IIf([Workday Sales Jul'12]![Bonus_Plan]="",[Workday Sales Jul'12]![Commission_Plan],[Workday Sales Jul'12]![Bonus_Plan])

I have no idea if I created that expression correctly or not, but it didn't work, needless to say.



Thanks.

[orange]

iif(col2> " ",col2,col1)
which translates to if col2 is greater than space, then use col2 else use col1

[Janae]

Worked like a charm, thank you!!