Hello, this is my sql in vba code
db.Execute "Update tblEOS Set tblEOS.[SCOPECAT] = " & Me.cboBusinessUnit & ">" & Me.cboWorkType & ">" & Me.SCOPECAT & _
" where ttblEOS.[RequestID] = " & Me.RequestID, dbFailOnError
but the value has a slash and I'm getting an error. how can I get around this?