Seperate Table Records

[daveofgv]

Hello All.

Is there a way (code wise) to have a table seperate itself as if:

field1 field2 field3 field4 field5
john chris angie paul susan


to end up like this:

john


chris angie paul susan

??????

In other words, I need field1 by itself in a record and field2-5 to move to the next record without field one.

--------- OR ---------

Is there a way when I export my tables using

DoCmd.TransferText acExportDelim, "newtabbed", "Table1", "C:\Test\test.txt", True, ""

to export record 1 of table1 - then record 1 of table2 - then record 2 of table1 - then record 2 of table2 and so on??????
basically back and forth between tables?????


If this dosn't make sense please let me know and I will try to explain better.

thanks

daveofgv

[ajetrumpet]

this kid of manipulation can only be done by recordset manipulation, because although this type of ? has been asked a million times in recent years, Access was not built for it, nonetheless. You don't have any other option, bud...other than exporting to excel, but the amount of time spent on doing the same thing would be equal I would think, regardless if it's excel or access.