Excluding records that contain wildcards

[AccessUser123]

I have a table where some of the records contain the wildcard character *. I need to generate a query that will select all records in the table except for those that contain *. I've tried entering the following query criteria:

<>"*"



But this returns all records in the table. Any ideas how to do this?

[June7]

If the only character is the * then: <>"[*]"
If there are other characters then: Not Like "*[*]*"

[AccessUser123]

Thanks, that worked. I actually have three data types I need to exclude:

Records that contain *
Records that contain ?
Records that contain a specific text string (#TextString1)

Using the criteria posted above, I can exclude all three of these types of records individually, but when I try to exclude all of them at the same time it doesn't work. Here's the criteria I've been trying to use:

Not Like "*[*]*" Or Not Like "*[?]*" Or Not Like "#TextString1"

I've tried a bunch of different variations on this but nothing seems to work. The query just returns all records in the table.

[AccessUser123]

I think I figured it out. I changed the "or" to "and" in the query criteria and now all three "not like" statements are working correctly. Thanks for your help!