Hi there again,
I have a problem I am trying to solve where I connect from excel VBA to and table in Access and I need to query the table for data. The table essentially contains a bunch of employees and I need to pull out the surnames of a group who have the same aircraft rating and their roles are either Captain or Co-Pilot. The SQL string needs to look something like this:
The above string obviously does not work but is my best guess as to how it should look.Code:strSql = "SELECT Surname FROM tblCrew WHERE [AW139]=-1 AND [Role] =" & """Captain"""" & "OR [Role] =" & """Co-Pilot""";"
Any help would be appreciated.
Kind regards,
Marcus