query criteria

  • Thread starter Thread starter Marty
  • Start date Start date
M

Marty

I need to search for a particular record and would like to
do it by typing in the first 5 or 10 letters of the
record. Is it possible to setup such a criteria in a
query? Thanks!!
 
This works for a simple select query - more involved if you want to use a
form to call your query....

This asks for the value of X and you can type 4-5 letters and get all values

SELECT Accounts.AccountName
FROM Accounts
WHERE ((left(Accounts.AccountName,10) Like (X) & "*"));
 
Back
Top