Removing A Specific Type Of Character From A Field, Access 2010

[mgarret]

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

[Beetle]

Use the Replace function;

Replace([YourField],"""","")

[mgarret]

Use the Replace function;

Replace([YourField],"""","")

I tried Replace ([May test.Child Name],""""," ") and Replace([May test.Participant],""""," ")

It didn't work. all the rows were deleted. What am I missing?

(May Test is the name of the table.)

[Beetle]

Where are you attempting to do this? In a query? In Code?

More details please.

[mgarret]

Either a query or sql code.

[Beetle]

It didn't work. all the rows were deleted.

There's no way the Replace function alone deleted rows from your table, so I don't know what you mean by this or what you did, but if you want to update existing rows in a table then the query syntax would look something like the following;

Update [YourTable] Set [YourField] = Replace([YourField], """", "");

Notice that's four double quotes then two double quotes. Don't insert a space inside the last set of double quotes unless you actually want to insert a space into the result in place of the existing double quote.

Do this on a backup copy of your app first, in case you don't get the results you expect.