Here's a tip as far as SQL is concerned. If you don't know how the statement should look, or your having problems getting it to work try this. Open MS Access and design a query. Create som bogus tables if you need to. After you have created the query and it give's you the correct result, click on View and then on SQL Statement. You will now see the SQL Statement for the query that you have just designed and you can use this in VB.

Hope it helps.

------------------
Hennie Pieterse
Senior Programmer
Datcor International
[email protected]
Telephone: +27 15 7816335
ICQ Number : 61636095
Today is yesterday's tomorrow