Wildcard in query

[Guest]

I am trying to use a wildcard in a query criteria. I have tool numbers, for
example:

Tool #
9537-57
6-2223-42
276150 0021
276150 0033

I would like to write a query that will select the two tool numbers with the
276150 beginning. Please help.

Thank you.

 

[Joan Wild]

In the criteria row under Tool # column
Like "276150*"

 

[Guest]

Try using Like in the query

Select * From TableName Where [Tool #] Like [Please enter a part number] & "*"

When running the query, the user will be prompt to enter a part number
If you want to search for a part of the string any where in the part number,
then use

Select * From TableName Where [Tool #] Like "*" & [Please enter a part
number] & "*"

 

[ginnyk]

I am trying to use a wildcard in a query criteria. I have tool numbers, for
example:

Tool #
9537-57
6-2223-42
276150 0021
276150 0033

I would like to write a query that will select the two tool numbers with the
276150 beginning. Please help.

Thank you.

Use the 'Like' keyword, rather than an equal sign.
Select Tool FROM Tools WHERE Tool# Like "276150*";