Hello everyone,
Im running a parameter query and I need it to show all records if left blank by the user.
I can achieve this but I cannot achieve it for more than one parameter.
How do i go about this?
Basically, if the user enters a value for the first parameter and enters nothing on the second one, i'd like to see all values for the first parameter.
any thoughts?
as always, much appreciated.
Im running a parameter query and I need it to show all records if left blank by the user.
I can achieve this but I cannot achieve it for more than one parameter.
How do i go about this?
Basically, if the user enters a value for the first parameter and enters nothing on the second one, i'd like to see all values for the first parameter.
any thoughts?
as always, much appreciated.