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
Code:
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