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 Shaun E on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
String used for comparison
Thanks - I think this will work but when I try to do the calculation from the query window i keep getting a "undefined function 'where' in expression" error message. I'm running Access 2003 and it looks like this may be a bug? I found a article from Microsoft that says the fix is to: start...- zeh
- Post #3
- Forum: Microsoft: Access Queries and JET SQL
-
String used for comparison
Can't figure out how to filter my data using a query based on one field being the substring comparison for another. My data is as follws: LAST NAME TAX NAME Powell Jamie Powell Smith Countrywide Home Loans Tomlinson Betty & Thomas Tomlinson I would like my criteria to be if...- zeh
- Thread
- Replies: 3
- Forum: Microsoft: Access Queries and JET SQL
