Does: SELECT DISTINCT a.[Name] , a.Email FROM tblOrders give you what you want? (Name is a reserved word in Jet SQL, so you need to use [] around the field name. I would usually recommend a more descriptive field name, eg Username or CustomerName or similar. Cheers Ken : -----Original Message----- : From: thelist-bounces at lists.evolt.org [mailto:thelist- : bounces at lists.evolt.org] On Behalf Of Maximillian Schwanekamp : Sent: Saturday, 22 January 2005 7:00 AM : To: TheList at Evolt : Subject: [thelist] Jet SQL help : : 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?