I am getting an error of Compile error: Expected: list seperator or ) when I attempt to run the below syntax in my VBA.
How in access 2013 vba can you accomodate for when a field contains open paren and close paren?Code:DoCmd.RunSQL ("Select [testtable].[UnitID], [testtable].[User ID (Where identified)] FROM [testtable]")