Also you can try this alternatively.
sql = "SELECT Employees.employee_id, Employees.user_id, Branch.branch_phone, " &_
"Users.l_name, Users.user_name, Users.f_name, Users.addr1, " & _
"Users.email FROM Employees, Branch, Users " & _
"WHERE Branch.branch = Users.addr1 and Employees.user_id = Users.user_id " & _
"and Employees.employee_id = " & to_sql(employee_id,"number")
And you can remove this & ""
at the end of your sql
string, which is required only when one needs to add a single quote around the employee_id
like this & "'"
, but in your case, not required as it seems to be a number.
Hope that helps.
- Vijay G
Strive for Perfection