DAT Column Order - Step 3 (DAT>Queries>Column Order)  allows you to drag and drop the fields into the order you want them to appear in your result.

Note:  Typically you would want the columns you are sorting by first to be the first columns appearing in your result.  However, the order the columns appear in the result, and the order that the data is sorted can be totally different.

See also
DAT   
PCR Educator K-12 School Information System is an online database engineered for independent and private schools to deliver the highest level of flexibility, unique experience, transparent communication and customized design. Being a complete cloud-based solution, PCR Educator system guarantees convenient access anytime, anywhere.