show all records in query if no value entered

[BradCollins]

Hi All,

I have a query that restricts my data to the selected truck number, and the last 3 digits of the trip number.
This works fine, and shows all the correct results, what I want to do now is in the same query show all trips for the selected truck of nothing is entered in the trip id field.

what I have is:

iif([RestrictSearch] is null, like "*", right([TripID],3))

it will still show the records based on the last 3 digits, but shows no records if the RestrictSearch field is blank.

Any help would be most appreciated. Thanks

 

[PHV]

Perhaps this ?

=Right([TripID],3) Or Trim([RestrictSearch] & '')=''

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[BradCollins]

PHV,

Thank you for such a quick response, I have tried this, and now it asks for an additional parameter to be entered, and also it now shows all records all the time.

Thanks again for your help

 

[BradCollins]

Thanks again, looks like it was my typing, it now works perfectly

Thank You