How can I read a record from an open database by sending a query.

example:
I open the database
I open a recordset with an SQL query
I read a single column (the only one retrieved)
I do some non database stuff
I make a new query and execute it
I read another column(the only one retrieved)
.
.
.
And so on
I then close the database.

please help