Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
How to filter out records that contain #
- Thread starter Janny
- Start date
Normally, you could use 'LIKE' in the query to find a string. For example to find anything with 'W' you'd use this in the criteria of the query's field:
Like "*W*"
However, it won't work for the hash, as it's used by access to delimit dates.
Instead, add a calculated field to the query:
HasHash: InStr(1,[myField],"#")
and in the criteria enter:
<>0
Max Hugen
Australia
Like "*W*"
However, it won't work for the hash, as it's used by access to delimit dates.
Instead, add a calculated field to the query:
HasHash: InStr(1,[myField],"#")
and in the criteria enter:
<>0
Max Hugen
Australia
- Thread starter
- #4
- Status
Similar threads
- Question
- Locked
- Question