Hi,i am a new user to access 2007.i have a select Query with partial name
input.The criteria goes like this-Like * & [Enter a Part Number] & *
Intially,everything was fine.But whenever i am entering data to my
database.and i tried to use the query,it always prompt me twice.I tried
closing access and opening it again.But it stil prompts me twice.Only when i
delete and re-enter the criteria again,then it works fine again.Please
help,is there something wrong with my way of writing the criteria?Thank you.