query criteria

[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!!

 

[Damon Heron]

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) & "*"));