retrieving all records while using a filter

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

Guest

This is probably a really simple question but i'm going to ask it anyway.

I have created a report that uses a filtered query. When the report is
opened, a form asks for the filter criteria. I need to figure out how to have
the report display all records if no filter criteria is entered into this
form.

Thanks
 
To pull all entries in a query when the prompt is blank us the following as
your criteria....

Like [Enter Some Parameter or Blank for all] & "*"
 
Back
Top