Many people ask for Work Item Queries to be interactive, to prompt the user for parameters. Noah Coad recently made a Work Item search tool available in his blog. You can find it here: http://blogs.msdn.com/noahc/archive/2007/03/08/search-work-items-team-system-addin.aspx.