Forum Discussion
Increment/decrement table columns
Hi! I have a table with two columns, column A and column B. Column A describes city of origin and column B describes city of destination. Between every row in the table i want to create a new row w...
tex628
Community Champion
Community ChampionI have a really tedious way that might work :-)
* Duplicate the query so you have #1 & #2
* Add index to both queries
* Split Column A and B in query #2 into two new queries, #3 & #4
* Make sure that you maintain the index from #2 in both #3 & #4
* Add +1 to the index of #4, which should hold a Column B
* Merge #3 & #4 back together on index
* Swap the names of the columns - A to B and B to A
* Append #1 & #2
I hope you can get something from this! :)
/ J