I would still suggest creating your view with parameters. The benefit to that is you do not have to mess with converting non-character values to strings and concatenating that to your SQL if you have any. WHERE ShelfQuantity = ?nQuant AND ShippingDate = ?dShip work for numeric and date values respectively without having to convert them in your SQL string.

>Trouble is, it's not just a query. They need all the amenities - update, add, delete etc - within the filtered criteria. Ultimately, I just felt a filter was slower to use overall than a view, so I went this direction with it. It works well, or did until this little bug jumped up and bit me. Your idea is reasonably easily adapted though.
>
>Even without using "Text To", I suppose it would have made sense to parametrise the view, but since I had actual concrete input, at the time I guess it just seemed easier to use the input directly.
>
>All the other views are parameterised and are based on the key of this particular view, but for whatever reason, I didn't do it that way with this dynamic view.