Thanks for the suggestions. The SP is probably the best route.

Wayne

"onedaywhen" wrote in message
ups.com...
Wayne Wengert wrote:
... from the user. The users know just enough to be dangerous
(<smile).

If you don't want them to change the SQL e.g. retain the same column
order, the same WHERE clause etc then put the query into a stored
procedure and call the proc from MS Query. They could of course still
completely change the call e.g. to another stored proc or write their
own SELECT query.

Jamie.

--