OzGrid / Et Al.
I have a query ( stored in access, called via VBA in excel ). Now the query as created returns a recordset which has 3 fields per record.
For this purpose say ( FieldA, FieldB, FieldC ).
What I want to know is this. After executing the stored procedure and getting back the recordset with 3 fields. Is is possible to remove FieldA and FieldB from the recordset. Which would leave me with a single column of information. Yes I can create a query which does this for me. But my database is quickly becomming populated with hundreds of different queries so I'm looking for ways to use existing queries.