lookup query question

  • Thread starter Thread starter Lanee
  • Start date Start date
L

Lanee

I am trying to create a query so that a user will be
prompted for criteria. The criteria would be for
example "9. Service" Is there anyway to tell the query
that if they answer with just "9" then it means they have
typed "9. Service". It's easier for the user to not have
to type as much.

Thanks
Lanee
 
FieldName: Whatever
Criteria: LIKE [Enter Value] & "*"

In SQL
SELECT <fieldlist>
FROM Tablename
WHERE SomeField LIKE [Enter Value] & "*"

That will find all values that begin with whatever is typed into the prompt.
Look up Parameter Queries in the on line help.
 
Back
Top