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!
-
Access Query Select Problem
When I use just the member_id i get all the records that I should get. When i use *like "*Alfred*" I also get the records. But I cant use the like clause because there may be many records with that name in it. I am looking for a specific client name to match what is in the database. I am...- datadch
- Post #3
- Forum: Microsoft: Access Queries and JET SQL
-
Access Query Select Problem
This seems like such a simple task but Access isnt cooperating. I am trying to run the following query select in MS Access 2000 and am getting no results even though I know that the data in the field (client_name)is valid. SELECT * FROM member_events WHERE member_id = 1 and client_name =...- datadch
- Thread
- Replies: 3
- Forum: Microsoft: Access Queries and JET SQL
