• Adr2 and Adr3.

    I want to use the column name instead of the variable in the if statement, because i have to set the variable = to the column anyway.

    Bit I cant say If ADR2 is null because it says invalid column name.

    I dont get errors if I say IF @ADR2, but I dont get the correct output because I havent set @ADR2 = to the column.