Show All Records

W

Walt

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
 
J

John Spencer (MVP)

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
 
Top