Show All Records

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

Guest

I would like to show all records if the user enters nothing in the select query parameter. Could someone let me know how to do this

Thanks
 
Set the criteria as

[Enter Requirement] OR [Enter Requirement] is Null

That should work with queries where you don't have a lot of criteria.

In an SQL statement that would be

SELECT stuff
FROM SomeTable
WHERE Somefield = [Enter Requirement] OR [Enter Requirement] is Null
 
Back
Top