Removing double-quote from field

[cmiker]

I am a little new to Access 2000. I import a comma-delimited text file into my database. I have an unwanted double-quote in two different fields of every record that I would like to remove. I am not sure what function to use and the syntax in the update query. This has gotta be simple! Can someone help?

Mike

 

[dcx693]

Is the double-quote in the same location in those two fields?

 

[cmiker]

double quotes

One double-quote is the first char in the first field. The second double-quote is the last char in the last field.

 

[Fornatian]

Use an update query to update the fields to:

Mid([YourField],2,Len([YourField])-2)

Should do it.

 

[dcx693]

...except that I think the quotation marks are in two different fields.

Use Mid([firstfield],2) to get rid of the first character in the first field and Left([secondfield],Len([secondfield])-1) to get rid of the last character in the second field.

 

[Fornatian]

Right you are.