Query Problems in access 2007

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
Try putting double quotes around both asterisks.

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
(e-mail address removed)
 
Back
Top