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
 
Top