Hi all—
I am trying to write a query in access which will modify these two fields. The leading quote (“) in Child Name and the trailing quote (“) in Participant need to be deleted. So, basically I need all the quotes deleted from these fields. Don’t know how to write for this.
Any assistance is greatly appreciated. Thanks!
Example:
Before:
Child Name
"Simth, Joe
"Simth, Joe
"Simth, Joe
"Simth, Joe
"Jones, Mary
"Jones, Mary
"Jones, Mary
"Jones, Mary
"Jones, Mary
"Roberts, Mike
"Roberts, Mike
"Roberts, Mike
"Roberts, Mike
Participant
Yes"
Yes"
"
No"
Yes"
"
Yes"
Yes"
"
No"
Yes"
After:
Child Name
Simth, Joe
Simth, Joe
Simth, Joe
Simth, Joe
Jones, Mary
Jones, Mary
Jones, Mary
Jones, Mary
Jones, Mary
Roberts, Mike
Roberts, Mike
Roberts, Mike
Roberts, Mike
Participant
Yes
Yes
No
Yes
Yes
Yes
No
Yes