Wild Card symbol

[rhonda11]

Does anyone know how to create a query that'll show me all records except a specified range? For example, I have a report that'll give me all project name, however, I what the report to eliminate a project name that start with "AES".

Thanks

 

[FancyPrairie]

Use the Query Builder and in the criteria section put in something like this:

Not Like "AES*"

The SQL version of the WHERE clause would look something like this:
WHERE (((YourFieldName) Not Like "AES*&quot);

 

[rhonda11]

Thank you so much, that works out great!

Happy New Year