Access 2003

[Guest]

In my datasheet view I have a column with text and quotations around it.
Example
field: Customer
"text"
"textA"
"textAA"
What function do I use in the design view to return the column in the
datasheet view without quotations.
text
textA
textAA
the Mid function does not work becuase the entries in my datasheet view are
of different lengths.

 

[Guest]

Try the Replace function.

DoNotQuoteCustomer: Replace([Customer], '"', "")

The trick is single-quote double-quote single-quote for the first argument
and double-quote double-quote for the second argument.