Special Characters Filter MS Access

[donf]

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

 

[IRstuff]

This is really better answered at Tek-tips.com, since their charter is computer software and hardware questions.

TTFN
faq731-376

 

[donf]

IRstuff,

Thank you. I'll try there.

donf

 

[AELLC]

donf,

There is a website:

http://www.excelforum.com

that has a forum dedicated to Access.

 

[donf]

I found the answer, and wanted to share it.

Surround the special character with []. In my case it would be: *[?]*.

Thanks to those who offered advice.

donf