Query using *

[Al-GA]

I want to pull a reocds of a same customer from various locations, but the
data is stores as customer name-location in one field. I know there is a way
to do it using using * at the end of the name but I dont know the code. can
anyone help?

 

[Roger Carlson]

I want to pull a reocds of a same customer from various locations, but the
data is stores as customer name-location in one field. I know there is a
way
to do it using using * at the end of the name but I dont know the code.
can
anyone help?

 

[Roger Carlson]

SELECT * FROM Customers
WHERE CustomerName-Location LIKE "Smith*"

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

 

[Stefan Hoffmann]

hi Roger,

SELECT * FROM Customers
WHERE CustomerName-Location LIKE "Smith*"

[]?


mfG
--> stefan <--

 

[Roger Carlson]

Quite right, assuming Customers is actually the table name and
[CustomerName-Location] is actually the field name:

SELECT * FROM Customers
WHERE [CustomerName-Location] LIKE "Smith*"

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

hi Roger,

SELECT * FROM Customers
WHERE CustomerName-Location LIKE "Smith*"

[]?


mfG
--> stefan <--