thanks Pat,

but if you use the query, it wont be dynamic rite? is there a way to make it dynamic, like when i run the 2nd query, it will execute the first query that counted the distinct recods?