Here's our Microsoft Office Tip for.. June 3, 2002
Click Here to see a complete list of all of our previously released Tips!
Faster Searches
You probably know that you can combine the LIKE operator with the * character to find approximate matches. For instance, all of the following are legitimate search strings:

LIKE "rabbits" LIKE "rab*" LIKE "*abbits" LIKE "*abb*

All of the above will match the string rabbits. However, LIKE "rabbits" and LIKE "rab*" are both faster than the other two examples. That's because Access sets a temporary index when you use the LIKE operator with an asterisk at the end of a string. When possible, use the asterisk character at the end of a LIKE search string.