Filtering on a part of a field

[opainc]

Using Edit-Find it is possible to select a record based on a string that is a part of a field. Can a table be filtered in the same way. That is 25678 North Main Street and all others with a <North Main> street address.

 

[PHV]

Something like this ?
Like "*North Main*" in the criteria row for the [street address] column in the advanced filter window.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[opainc]

Thank you PHV. Would you reccomend a text book for Access 2000? I have Access 2000 fro Dummies and it is really for Dummies.

Carl