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