Andy Ralph-Kineteco
New member
- Local time
- Today, 14:59
- Joined
- Mar 12, 2014
- Messages
- 6
Hi all, Having a senior moment I presume...
I am using Access 2013 under Windows 7.
I have a table (tblStock) with a field called "Description".
Some 25% of the records hold the following data - "DNU - ....." (meaning "Do Not Use - ....) the others hold data such as "Spring" or "Plunger".
In a Select Query to find all records without this prefix in the Description Field, I tried to use the following criterion:
Not "dnu*"
This returned no records at all.
I tried:
Not Like "dnu*"
again no records and it also changed the criterion to:
Not Alike "dnu*"
Any ideas please? :banghead:
Thanks
Andy Ralph
I am using Access 2013 under Windows 7.
I have a table (tblStock) with a field called "Description".
Some 25% of the records hold the following data - "DNU - ....." (meaning "Do Not Use - ....) the others hold data such as "Spring" or "Plunger".
In a Select Query to find all records without this prefix in the Description Field, I tried to use the following criterion:
Not "dnu*"
This returned no records at all.
I tried:
Not Like "dnu*"
again no records and it also changed the criterion to:
Not Alike "dnu*"
Any ideas please? :banghead:
Thanks
Andy Ralph