Can I remove a column from a recordset

[SpiritOfLennon]

Hi,
I have a recordset with about 15 columns, however I only want data from 3 of the columns. How can I easily create a new recordset with just the columns of data I need? i.e. can I drop unwanted columns from the recordset or create a subset of the recordset?
Regards SOL

SOL
I'm only guessing but my guess work generally works for me.

 

[neilharris]

Can you not just rewrite the SQL for the original recordset so that it only returns the necessary data.

 

[petermeachem]

Are you doing SELECT * FROM ... ?
if so do SELECT field1,field3,field7 FROM ...

http://www.accuflight.com

http://www.lettersdirect.co.uk

http://www.ourhouseinportugal.co.uk/

 

[SpiritOfLennon]

Yeah thanks guys, I realised this almost as soon as I posted the question. Must be one of my dumb days. I seem to be getting more of these the older I get.

SOL
I'm only guessing but my guess work generally works for me.