MS Access 2003 Queries?
I'm doing a school project that requires me to make queries for a movie database in MS Access 03. One of these queries is for Video names that begin with "T". However, if I type in: Like "*T*" it simply includes any movie with a 't' in the name vs. movies that begin with "T". If anyone knows how to write the formula for this function it'd be great! Also if you know of a website that is easy to understand with a list of functions it would be appreciated and very helpful. Thank you!
- BlueFeatherLv 610 years agoFavorite Answer
Use Like "T*" (no leading wildcard) to get records where the name begins with T.
Use Like "*T" (no trailing wildcard) for records where the name ends with T.
Like "*T* yields records with a T anywhere in the name (as you already found out)
If you have more questions, please feel free to ask (see profile).
Some Useful links:
Access 2003 VBA Programmer's Reference
Access 2003 Solution Center
MS Office Discussion groupsSource(s): 15 years experience with MS Access