How to make a Partial Search Query or partial search function
To search for a partial entry you would do something like...
Like *hydro*
This would find the string "hydro" anywhere in the field.
Rick B
"Le Tran" wrote in message
...
Hi all,
I have a Chemical table that contain all chemical. I need to search for
their name offten. If there is not this chemical in the table, I will input
this chemical. If the chemical already in the table, I will not to input it.
However, find function in access just find the exactly name of chemical. If
I have a mistake in typing the name of chemical (this happens all the time),
the result will be nothing.
I want to make a query that just input partial of the name of chemical then
list all of the chemicals that have almost the same name.
Are there any suggestion that would hepl,
Thanks,
--
Le Tran
|