Could you post the query (with the sub query) maybe I can help you build it using joins or they might be someone else who knows more in SQL and can help out. Moi -- Moises Kirsch <moi(at)kirsch.com.mx> Never underestimate the power of stupid people in large groups.