Show All Records

[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

 

[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