criteria help

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

Guest

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