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...
 
Back
Top