Special Characters Filter MS Access
Special Characters Filter MS Access
(OP)
I have an Access 2000 database with a number of records with "xxx?" in one of the fields. I'm trying to filter for the records that contain only a ? at the end. Since "?" is a special character, how do I contruct the filter to treat the "?" as text?
Many Thanks,
Donf
p.s. I did spend a half hour using the search feature in this forum. No results
Many Thanks,
Donf
p.s. I did spend a half hour using the search feature in this forum. No results





RE: Special Characters Filter MS Access
TTFN

FAQ731-376: Eng-Tips.com Forum Policies
RE: Special Characters Filter MS Access
Thank you. I'll try there.
donf
RE: Special Characters Filter MS Access
There is a website: www.excelforum.com that has a forum dedicated to Access.
RE: Special Characters Filter MS Access
Surround the special character with []. In my case it would be: *[?]*.
Thanks to those who offered advice.
donf