The links below provide some technical documentation for you. You should find the information you need in the the second technical article within the "The SELECT INTO Statement" section. Fundamental Microsoft Jet SQL for Access 2000 http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnacc2k/html/acfundsql.asp Intermediate Microsoft Jet SQL for Access 2000 http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnacc2k/html/acintsql.asp Advanced Microsoft Jet SQL for Access 2000 http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnacc2k/html/acadvsql.asp Regards, MP >>> lists at neptunewebworks.com 1/21/2005 3:00:03 PM >>> This ought to be simple, but apparently my brain is tiny and reptilian. I have an Access 2k db with a table of orders, and I'm trying to build a customers table. tblOrders is something like this: OrderID Name Email Amount 1000 John Doe john at example.com 5.00 1001 Jane Doe jane at example.com 12.00 1002 John Doe john at example.com 11.00 1003 José Doe jose at example.net 78.00 1004 José Doe jose at example.net 13.50 From this, I want to derive this Access RS: Name Email John Doe john at example.com Jane Doe jane at example.com José Doe jose at example.com Anyone wanna help me out with the Jet SQL here? -- Maximillian Von Schwanekamp Dynamic Websites and E-Commerce NeptuneWebworks.com <http://www.neptunewebworks.com/> voice: 541-302-1438 fax: 208-730-6504 -- * * Please support the community that supports you. * * http://evolt.org/help_support_evolt/ For unsubscribe and other options, including the Tip Harvester and archives of thelist go to: http://lists.evolt.org Workers of the Web, evolt !