Sort by Date in Crosstab Query

[Tophan]

How can I sort a crosstab query by the date field? The table/query used in the crosstab has a date field which enters the information as dd/mm/yyyy format.

This date field is a column heading in my crosstab query and it is sorting the columns by the day field and not in date order

e.g. the column heading are as follows:
01/05/2016
03/07/2016
05/06/2016
08/05/2016

Is there any way I can sort in the correct order i.e.
01/05/2016
08/05/2016
05/06/2016
03/07/2016

 

[Ranman256]

You'll have to format the date as yyyymmdd to sort correctly.

 

[Ranman256]

Or use 2 columns,1 to sort yyyymmdd
And 1 to view, mm/dd/yyyy

 

[Tophan]

Thank you both. Changing the date format to yyyymmdd worked -

Format([WkEnding],"yyyy/mm/dd")