fernando.rosales
Registered User.
- Local time
- Today, 01:43
- Joined
- Jun 11, 2014
- Messages
- 27
Hi everyone I have a statement which works fine if the value of the cell does not contain any special characters. The problem is if the value contains a ' symbol than it does not work. How can I work around this?
Example:
tbl_audit_summary table
Audit Area = DD's Area
Business = null
tbl_area_list
Area = DD's Area
Business = dd's
End result:
tbl_audit_summary table
Audit Area = DD's Area
Business = null -- Not working, should be dd's after the statement
Code:
DoCmd.RunSQL "UPDATE tbl_Audit_summary INNER JOIN tbl_area_list_tmp ON (tbl_Audit_summary.audit_area = tbl_area_list_tmp.area) SET tbl_Audit_summary.business = [tbl_area_list_tmp].[business] where tbl_Audit_summary.business is null"
tbl_audit_summary table
Audit Area = DD's Area
Business = null
tbl_area_list
Area = DD's Area
Business = dd's
End result:
tbl_audit_summary table
Audit Area = DD's Area
Business = null -- Not working, should be dd's after the statement