[AccessD] Query Grid - Exact Match

Dan Waters dwaters at usinternet.com
Mon Jan 5 11:30:27 CST 2009


Hi Tony,

Take a look at Like in the help file.  It might be what you're looking for.

Dan

-----Original Message-----
Subject: [AccessD] Query Grid - Exact Match

Hey All
Just wondering if there is an easy way using the query grid to find the 
exact word only in a string in a text field. I have done it, but I am 
using instr(), ASC() tests, etc. to pull an exact match. Just thinking 
there must be an easier way.
Example find exact word Time
Text
1. The time is 9 o'clock
2. The timer has been set
3. Please enter Time/Day/Month
4. Please enter Time&Day&Month
5. Time is on your side
6. All timesheets required by 4 oclock
7. Please enter Day/Month/Time
8. Last recorder time9 PM
9. Please enter TimeandDay
10. Please set the timertoff

Would like only records 1,3,4,5,7 and 8 to be displayed and my query 
currently does that.  9 (like to get) and 10(would be punted) can be 
possibly be done with some  tweaking, but kind of messy.




More information about the AccessD mailing list