Understanding VB6, Access 2000, DAO, SQL Queries
Posted on 2006-07-12
I'm a new VB programmer and I'm writing an application to manipulate stock market data. I have an Access 2000 database that I process using VB6, referencing DAO. I want to declare two record sets and using one recordset as an input stream, cycle through the second recordset and process the data.
For the first recordset, I need to retreicve all columns of the first 25 rows sorted in decending sequence by NumFieldA.
The second recordset is the entire database.
Now, I need to find the symbol for each row in recordset 1 in recordset 2 and perform certain processing.
My question: Can anyone help me code the SQL SELECT statements to do the above? I can provide additional information if needed. Thanks for your help!