 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Queries / November 2005how to make a query using SQL to get customer info by typing telep
how to make a query using SQL to get customer info by just entering the telephone number? >how to make a query using SQL to get customer info by just entering the >telephone number? Well, of course, the SQL will depend totally on the structure of your table, and what customer info you want. In short, assuming that the telephone number is just a field named Phone in the table named Customers: SELECT * FROM Customers WHERE Phone = [Enter phone number:]; John W. Vinson[MVP] Thank you John: This is my first time creating a database,:) your post help me a lot, but gave me all customers records, not only the one that I'm asking about. The idea is to only get the customer record where the telephone number matches. Any hint? Thank you again > >how to make a query using SQL to get customer info by just entering the > >telephone number? [quoted text clipped - 7 lines] > > John W. Vinson[MVP] > Thank you John: > This is my first time creating a database,:) > your post help me a lot, but gave me all customers records, not only > the one that I'm asking about. The idea is to only get the customer > record where the telephone number matches. > Any hint? John's example query includes a parameter that should prompt you for a specific phone number when you run it. If you enter a particular customer's phone number then that is the only record the query should return.  SignatureI don't check the Email account attached to this message. Send instead to... RBrandt at Hunter dot com Thank you both, I realize what the problem was( some error in table's field name) so now the queryis working fine :) > > Thank you John: > > This is my first time creating a database,:) [quoted text clipped - 6 lines] > phone number when you run it. If you enter a particular customer's phone number > then that is the only record the query should return. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.