Finding "Single Quotes" and replacing with a "Space"
I've just written a report and in one of the fields, the Full_Address, I get entries such as:
Flat 1 99 Rowland's Road PO36 3XX
Unfortunately, this single quote causes issues once the data is extracted and used in an access database. I'm asking if there is anyway i can replace the quote. I browsed the forum but could not find the right answer anywhere.
This is what i'm currently using but brings back the same thing, no change:
Replace(Addr_Supply,FindOneOf(Addr_Supply,chr(39)), '') OR