Thread: Filtering for fields with character
View Single Post
  #1  
Old May 15th, 2010, 03:00 PM posted to microsoft.public.access.queries
Louis[_8_]
external usenet poster
  
Posts: 1
Default Filtering for fields with character
How can I filter for results that contain the charcter "(" ?

For example if my fields a

A(2001)
B(2004)
C
D(2055)
E(2006)

I would like to display results that contain parentheses brackets.

I try filtering using the wildcard *(* but it does not work.