Sort Your Crosstab Query Row/Column Headers

In this Microsoft Access tutorial I will teach you how to sort the row and column headers in your crosstab queries in either ascending or descending order.

Debra from Northport, New York (a Platinum Member) asks: When I run my crosstab query it is pulling the dates as column headers, but they are all out of order. How can I fix this?

Prerequisites

• Invoicing: https://599cd.com/Invoicing
• Crosstab: https://599cd.com/CrossTab

Update

• Remember, if you manually move (click and drag) the columns around in query view, that layout will sometimes save and cause problems later if your data changes. Don't move the columns around, especially if they're date based. If you want to make manual adjustments, I recommend copying and pasting that data into Excel.

Links

• ISO Date Format: https://599cd.com/ISO
• SQL with Access: https://599cd.com/SQLwithAccess

Recommended Courses

• Access Expert 18: https://599cd.com/ACX18

Learn More FREE Access Beginner Level 1 FREE Access Quick Start in 30 Minutes Access Level 2 for just $1 Free Templates TechHelp Free Templates Blank Template Contact Management Order Entry & Invoicing More Access Templates

Resources Diamond Sponsors - Information on our Sponsors Mailing List - Get emails when new videos released Consulting - Need help with your database Tip Jar - Your tips are graciously accepted Questions? Please feel free to post your questions or comments below or post them in the Forums.

Keywords

access 2016, access 2019, access 2021, access 365, microsoft access, ms access, ms access tutorial, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database, How can I sort the columns in a crosstab query, sorting columns in a crosstab query, How to change the Sort Order of Column Headings, column display order, How to Order the Rows in an Access Crosstab Query, Arrange Columns in Required Order in CrossTab