queries

[minnesotagirl]

how can i write a query to find results that include any data with only part
of the data in a field? For example, I want to find all records with
customer name of smith, regardless of whether the record lists the name as
smith, bill or smith, william.

 

[Dirk Goldgar]

Otherwise you may use the LIKE operator:

SELECT *
FROM yourTable
WHERE yourField LIKE 'Smith%'

This query can use an index on your field. If your field may contain Smith
at any position use

WHERE yourField LIKE '%Smith%'

Note that Stefan has given you the SQL-Server-compatible wild card character
'%'. If you are using an .mdb or .accdb file, then this is not the default
wild-card character. In that case, you would use '*' as the wild-card
character instead.

 

[minnesotagirl]

can I use this with a parameter query? How I format it?

 

[Dirk Goldgar]

can I use this with a parameter query? How I format it?

For example,

SELECT *
FROM yourTable
WHERE yourField LIKE '*' & [Enter name:] & '*'