Not Like is notoriously slow in ACCESS.
Assuming that you have a primary key field in the table, this type of query
might run somewhat faster:
Create a query (name it qryLike) and save it:
SELECT PrimaryKeyField
FROM TableName
WHERE FieldName Like "*TX[0-9]*";
Then create this query to show the results you want:
SELECT *
FROM TableName LEFT JOIN
qryLike ON TableName.PrimaryKeyField =
qryLike.PrimaryKeyField
WHERE qryLike.PrimaryKeyField IS NULL;
--
Ken Snell
<MS ACCESS MVP>
Prav said:
Sorry i mad a mistake i'm using Not Like "*TX[0-9]*" in a query and its
forever to run. However
if i do Like "*TX[0-9]*" its works fine. Any other way to query NOT LIKE.
Prav said:
Hi i'm using Not Like "*TX[0-9]*" in a query and its forever to run.
However
if i do Not Like "*TX[0-9]*" its works fine. Any other way to query NOT
LIKE.
