Reading columns

[coyotem78]

Hi

I'm writing VB code to go thru a table in Access. My question is instead of naming the column (field) names individually (there could be 27+ columns), is there a way for me go to the next column?

If this is a bit confusing, post a reply and I will clarify.

Thanks in advance

coyotem78

 

[Parra]

So you have a field, with different data and you want it organized?

I have a table with a field with 15 possibilities "entries of data". I created a query that will "extract" the data and put it under the correct field.

In table
red
green
white
Blue

In query
red green white blue

Is this what you are looking for?

 

[coyotem78]

It ok now! I've solved it! Just wrote VB code to get a row at a time instead. Thanks anyway!

Although, is there a way to put an array of, long integers say, back to any Access or Excel Table?

Thanks

coyotem78