Russ
Yes, that should work. What that would do first is select all records which have "cool" in the one column, and then of those records select the ones which are "Between Date() And Date()-7)"
What happens when you run the query?
If things still don't work properly, you could post the SQL for the query.
Tom