criteria help

  • Thread starter Deer in head lights
  • Start date
D

Deer in head lights

In a query under four fields I have the criteria

Like "*" & [Type ...] &"*"

However, when nothing is typed in the criteria, it does not full all the
records. How do I make it so that when left blank, the criteria is blank or
Like "*".
 
Top