Add this to your SQL statement:
WHERE Left([theField],3) = [Enter the first three letters]
Or, in the design grid, start a new column, enter the expression
left(theField,3)
and put in the criteria row
[Enter the first three letters]
If you want to enter the three letters from code, or from a form, you
need a slight change. But you didn't mention the user interface.
Chuck Insight wrote:
Hi All,
I need a query that allows users to enter the first three letters of a
field, and list all records that match.
Thanks, Chuck
--
Bas Cost Budde, Holland
http://www.heuveltop.nl/BasCB/msac_index.html
For human replies, replace the queue with a tea