Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Access Query to Re-arrange Tables
I don't see how "Order By" will work. Sequence# = NextStep#. In the second table the sequence# is not in numerical order. If I am missing something then perhaps you can send the SQL code that will select from table 1 and output table 2.- marklaw01
- Post #3
- Forum: Microsoft: Access Queries and JET SQL
-
Access Query to Re-arrange Tables
I want to use SQL to re-arrange the records in a table. In the first table below, the records are arranged in numerical step order. I want to re-arrange them in next step order. If we start with the first table below, the query should generate the second table below. It does not matter if we...- marklaw01
- Thread
- Replies: 2
- Forum: Microsoft: Access Queries and JET SQL
-
SQL Table Pivot-like Requirement
I have modified the requirement to include a row number column at the beginning of each table. I want to use SQL to re-arrange the records in a table. In the first table below, the records are arranged in numerical step order. We want them re-arranged in next step order. If we start with the... -
SQL Table Pivot-like Requirement
I want to use SQL to re-arrange the records in a table. In the first table below, the records are arranged in numerical step order. We want them re-arranged in next step order. If we start with the first table below, the query should generate the second table below. It does not matter if we...
