Criteria

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

Guest

I crated a Query from a table. One field is called Item. On the criteria line
in the query I have [Enter Model Number] which gives me a pop up that says
that. If I type a item in there that item comes up. The issue I have is if I
do not type anything in the pop up I would like all the items to come up.
 
Use this as your criteria:

Like IIF(IsNull([Enter Model Number]),"*",[Enter Model Number])
I crated a Query from a table. One field is called Item. On the criteria line
in the query I have [Enter Model Number] which gives me a pop up that says
that. If I type a item in there that item comes up. The issue I have is if I
do not type anything in the pop up I would like all the items to come up.
Click to expand...
 
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

search multiple criteria 0
Access Dcount (multiple criteria) 3
Criteria on a field, but also pull other data 7
Query with Multiple Criteria 1
HELP! Query Criteria not returning data 2
or in query 2
Can a query be ran by check boxes in a form? 1
Use In() Expression as Query criteria with guts from Function 1

Back
Top