Parameter query to show all if nothing is entered (1 Viewer)

BCS

New member
Local time
Yesterday, 23:46
Joined
Dec 22, 2011
Messages
1
I need to build a parameter query to show parameter results if something is imputed but if nothing is imputed I need the query to show all records. I also need it to be on a query with multiple parameters. But Jack Cowley had posted a response telling another to use a query by form with a query def. I Am not very knowledgeable with this and would like to know if there is another way? Maybe setting the query up with parameters set and then building an expression after that would prompt each parameter to display all records if no criteria is imputed into parameter box?:confused:
 

Millah

Registered User.
Local time
Yesterday, 23:46
Joined
Dec 27, 2011
Messages
12
Try something like WHERE (Param1 IS NULL or Table.Field = Param1)
 

Users who are viewing this thread

Top Bottom