Stic with Nick's suggestion. Mine is a little more advanced in that you dont
specify the query but rather the SQL statement that generates the query
results...

"Laurent M" wrote:

thanks nick your answer seems nice, but i don't have time to test it yet

jim i dont 't get where you specify the access query, i'm actually quite a
beginner in vba