• There are a couple of ways to exclude specific records from your query results. The most common is: Not Like "apples" and Not Like "oranges" and Not Like "pears"However that gets pretty ugly if you have 5 or 10 records you want to exclude. The other option is:Not In("apples","oranges","Pears")Be aware that the syntax in SQL Server T-SQL is somewhat different. Also, the quote characters are necessary for text fields but not for numeric values.

    Wendell
    Colorful Colorado
    You can't see the view if you don't climb the mountain!