Combining Columns and Replacing Certain Values

[Kellen]

I need to create a query that combines two columns (lets say Column A and Column B for example) however the problem is that whatever non-null values that are in Column B must replace any value in Column A. If Column B has a value that is null then Column A's value is shown.

I have an example of what I'm working with (access file) and what result I want (excel file).

Thanks in advance.

 

[MarkK]

Try an "immediate if" . . .

colC: IIF(Not IsNull(colB), colB, colA)

Hope that helps,

 

[Kellen]

Try an "immediate if" . . .

colC: IIF(Not IsNull(colB), colB, colA)

Hope that helps,

It worked. Thanks a bunch.

I must be over-thinking things when a simple IIf statement was all I needed.