I don't know how to dynamically change the WHERE clause in SQL. You can use parameters to pass different values to the WHERE clause, but not actually change the conditions in it. However, there is a command in SQL to excecute a string value. I forget what it it is, but you could research it and see if you can put that in a SQL Command object so that you can enter a string parameter in the report and SQL will execute it for you. It's a long shot, but something worth researching.