obtain specific rows and column from access table

Hi All,

i'm wanting to loop through an access table and pick out specific fields from each recordset. for example i want the first and third field of every row?

i can extract all of the record easily just struggling to do this?

For simplicity sake lets just say my database is "c:\database.mdb" and my table is called "table" and the fields are called F1, F2 and F3.

i assumed it would be similar to an array so (this would select row 1 column 1):

Please Login or Register  to view this content.

any help is really appreciated.

Hi Mate, not quite.

i am basically trying to populate a treeview with the data. but i'll need all the fields but only want to show certain ones, does that help?

I've sussed it out:

Please Login or Register  to view this content.

Hope this helps folks