Hi!

Please ignore the above. The Union Query video teaches something much better.

I'm still a Rookie and new to VBA and understanding the IF-THEN-ELSE conditions.

My union query is based off 3 tables. I understand the IF-ELSE part when dealing with 2 tables. But for 3rd table, I can't use ELSE a second time for the third condition without an error message.

How can I properly make the expression work?

Have attached screenshot.

You use ElseIf

If Something Then
'some code
ElseIf Something Then
'somecode
ElseIf Something Then
'some more code
Else
'this is the code for ALL other options that weren't specified already, Something wasn't equal to the first 3 statements than it automatically goes here.
End If

I'm not sure what you have going on exactly so just guessing, but with your option it could maybe be

If OfficerList.Column(11) = "Director" Then
'code
ElseIf OfficerList.Column(11) = "Some other position" Then
'code
Else
'all other positions
End if

Or you could Just do If ElseIf ElseIf and than not do anything if it isn't one of those options.

YES!!! It works!!

Thank you so much Adam! When I get these issues I try to read online or watch youtube help videos, but to me they're speaking Klingon :)

You guys explain things so much better!

Glad to hear it works ;).

That's why I have a comprehensive course that teaches these things. Much better than watching random YouTube videos. Hint hint. :)