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.
Mark McCasland
Midlothian, TX USA