I have email addresses that have a carriage return at the end of the email. I am trying to do an Update Query to removed them. Here is the SQL I have:
UPDATE Tbl_DO_Stakeholder_data SET Tbl_DO_Stakeholder_data.PCO_Email = Replace([Tbl_DO_Stakeholder_data]![PCO_EMail],Chr(13)+Chr(10),"")
When I run it, it want me to enter the parameter for Tbl_DO_Stakeholder_data!PCO_Email
What am I doing wrong?