Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
parameter query; showing all
- Thread starter trustsun
- Start date
Provided the searched field is text, you may consider change the criteria from:
[Enter parameter]
to something like this:
Like Iif(Len(Trim([Enter parameter]))=0,"*",[Enter parameter])
Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244
[Enter parameter]
to something like this:
Like Iif(Len(Trim([Enter parameter]))=0,"*",[Enter parameter])
Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244
- Thread starter
- #3
Ah, it's a date parameter.
So, don't change the criteria, but in the Or row you may put something like this:
Len(Trim(CStr([Enter parameter])))=0
Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244
So, don't change the criteria, but in the Or row you may put something like this:
Len(Trim(CStr([Enter parameter])))=0
Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244
- Thread starter
- #5
- Status
Similar threads
- Question
- Question