[thelist] Jet SQL help

Maximillian Schwanekamp lists at neptunewebworks.com
Fri Jan 21 14:00:03 CST 2005


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





More information about the thelist mailing list