[thelist] Jet SQL help

Michael Pack michaelpack at wvdhhr.org
Fri Jan 21 14:33:56 CST 2005


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 ! 



More information about the thelist mailing list