I am trying to build a query to look through a list for entries that end with a number enclosed in parentheses. Any suggestions?

In your query's criteria section for that field, enter this as the criteria:

Like "*(?)"
Like "*(??)"

The first one gives you any one-digit number. The second gives you any two-digit number, etc. Remember to include the word LIKE in your criteria. It's a key word.

The * wildcard signifies that anything can be before the (.
The ? wildcard(s) signifies that one (two, etc.) characters can be inside the ().



Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division

If there's a possibility that the brackets at the end of the string may contain letters, you can make the pattern even more exact by using the following:

Like "*([0-9])"
Like "*([0-9][0-9])"

Where [0-9] means ensure that the character in this position is between 0 and 9.


Brian Skelton
Braxis Computer Services Ltd.

Greg, Brian .... thanks guys, it worked great. I also needed to get a field that contained only the four digit number, but I worked that out myself. Thanks again... Ray