How can I sort the column heading in MS Access for more than 30 columns

Example:

Roll_Number |   Class   |   Subject     |   Marks   |   DOB
------------+-----------+---------------+-----------+------------
1           |   11      |   Chemistry   |   50      |   14-05-96
2           |   12      |   Physics     |   62      |   15-02-93

It should be like

Class   |   DOB         |   Marks   |   Roll_Number |   Subject
--------+---------------+-----------+---------------+--------------
11      |   14-05-96    |   50      |   1           |   Chemistry
12      |   15-02-93    |   62      |   2           |   Physics

Source: New Questions

Leave a Reply