Can someone correct this query for me:
sql = "SELECT * FROM Risk_Acceptance where Acceptance_No = "& search_view & " "
search_view is the input field which would return results of the search action.
Getting the following error:
Error Type:
Microsoft JET Database Engine (0x80040E14)
Syntax error (missing operator) in query expression 'Acceptance_No ='.