Search results

Great, thanks a mill :D

a subset of the data is attached. :o

Once i put IIf(Not IsNull([Locally Assigned RB]) And Not IsNull([Assigned RB]),[Locally Assigned RB],[Locally Assigned RB] & [Assigned RB]) into my criteria of my 3rd column and hit Run, it comes up with 0 records found.

i put that in Column C: but get no results :( IIf(Not IsNull([Locally Assigned RB]) And Not IsNull([Assigned RB]),[Locally Assigned RB],[Locally Assigned RB] & [Assigned RB]) ---Locally Assigned RB = Column A and Assigned RB = Column B--

thanks a million. giving it a try now :D

If both columns are populated then i'll use whats in Column A

i can't because sometimes both Column A and Column B has Values in it. Needs to be the "IF" statement & also needs to be done in Access.

Hi i need help using the "IF" function i think. Basically i have 2 "columns" A B aaa aaa aaa aaa Basically if i have say Column A that has some fields filled in and Column B...