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)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Query problem 1
access 2007 criteria in query 2
Parameter query issue in Access 2003 6
Query wizard in Access 2003 vs 2007 3
update query using like criteria 3
Ampersand in Query Criteria 10
simple select query variable question 3
Query prompt one column for multiple random values 1

Back
Top