Casey Crookston <casey at thecrookstons.com> wrote: > How in the name-of-the-sql gods does one build such a select statement? > Or, is it better to have three recordset objects <...> In your case, almost certainly the latter; however, should you ever really need recordsets-within-recordsets in the future though, what you're after is called 'Data Shaping', which is available with some ADO providers. Explanation here: <http://www.4guysfromrolla.com/webtech/092599-1.shtml> Cheers, Paul.