Nightlytic
Member
Hi,
I found this trick in a book, where you are able to enter multiple parameters into a parameter prompt box, just separate them, for example you can have "Apple", "Banana", "Orange" and field Cost Element there will look for those, return no number for mismatches and therefore fail criteria >0.
Problem is, if I hit enter (no input) the result is InStr("","") and nothing gets returned.
Can anyone please suggest a way to return all results, if [Enter Cost Element] is nothing.
Parameters:

The SQL statement is
WHERE (((InStr([Enter Cost Element],[Cost Element]))>0))
I'm thinking something along the lines of WHERE but then OR [Enter Cost Element]&"*"
wildcard to return everything if the input is blank? I'm tots fresh to SQL :/
Concious Chandoo isn't the go to place for Access help, sorry, I just don't do other forums at the moment.
I found this trick in a book, where you are able to enter multiple parameters into a parameter prompt box, just separate them, for example you can have "Apple", "Banana", "Orange" and field Cost Element there will look for those, return no number for mismatches and therefore fail criteria >0.
Problem is, if I hit enter (no input) the result is InStr("","") and nothing gets returned.
Can anyone please suggest a way to return all results, if [Enter Cost Element] is nothing.
Parameters:

The SQL statement is
WHERE (((InStr([Enter Cost Element],[Cost Element]))>0))
I'm thinking something along the lines of WHERE but then OR [Enter Cost Element]&"*"
wildcard to return everything if the input is blank? I'm tots fresh to SQL :/
Concious Chandoo isn't the go to place for Access help, sorry, I just don't do other forums at the moment.