Retrieve mulitple fields as one result

[AlexanderBB]

Is it possible to extract either all columns or a range of columns (e.g 25 to 255) from a table as one result ?
Or a method to concatenate each field (without looping through one by one ) ?

 

[Andrew Fergus]

Do you mean in VBA? What are you trying to achieve?

 

[AlexanderBB]

I've been using the query design grid for testing, but eventually it will be sql in VBA.

e.g.
Set t = db.OpenRecordset("Select * from tblTest;")

Then I can return t(0), t(1), etc.

But the wanted result is t(25) & t(26)..... & t(255)
I'm hoping there's an alternative method to avoid building up via a loop.

 

[Andrew Fergus]

Not that I am aware of sorry - I don't think you can avoid using a loop. Even if you assigned it all to one variable it would end up being an array of results much like you have indicated, which would still require a loop to process. Is there any reason you want to avoid using loops?

 

[AlexanderBB]

Only that it might have been quicker, and more compact code.
The loop is pretty quick though.
Thanks for replying.