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