PDA

View Full Version : Extract and manipulate a field using SQL



mud2
04-24-2006, 06:30 AM
SQL seems "easy" to use provided you restrict yourself to tables. How do I use SQL to extract data from a particular field, so that I can work with it. I.e, extract to a VBA variable, make decisions on its value...etc...?

I could open the table as a record set and extract the data from it, but that seems to defeat the use of SQL!

As for my last...unanswered question...I got around it by writing a non-class stack.

Thanks!

OBP
04-24-2006, 08:41 AM
You can do what you want with the SQL, but to manipulate with decisions in VB you really need the data to be in a Recordset Clone or a Form Recordset.
The other way that is possible is to run sequential SQL (Queries) to do the same thing.