Query using *

  • Thread starter Thread starter Al-GA
  • Start date Start date
A

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?
 
Al-GA said:
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?
Click to expand...
 
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


Stefan Hoffmann said:
hi Roger,

Roger said:
SELECT * FROM Customers
WHERE CustomerName-Location LIKE "Smith*"
Click to expand...
[]?


mfG
--> stefan <--
Click to expand...
 
Back
Top