Removing Speech Marks in a table field

A

AJCB

I was wondering if anyone could help me?

I have in my database fields that sometimes pull over with speech marks at
the beginning and end of each field. For example, the field will show "9590"
or "12345$12"

Would I use an IIf statement combined with a Trim statement?
If yes, what would be an example of what to put?
If no, what should I do?

Cheers
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top