how to make a query using SQL to get customer info by typing telep

  • Thread starter Thread starter Guest
  • Start date Start date
how to make a query using SQL to get customer info by just entering the
telephone number?
Click to expand...

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


John Vinson said:
how to make a query using SQL to get customer info by just entering the
telephone number?
Click to expand...

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]
Click to expand...
 
colladita said:
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?
Click to expand...

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.
 
Thank you both, I realize what the problem was( some error in table's field
name) so now the queryis working fine
:)
 
Back
Top