B
Brian
I have a pivot table that summarizes payments by month. The underlying query
has the payment dates sorted by ascending date. I have an expression that
changes that date to mm-yy format (Format([pmtDate],"mm-yy").
The query results come out properly sorted but when I display the pivot
table, it wants to sort the dates alphabetically by month instead of
chronologically. Is this because the format expression is changing it into a
text format, and if so how can I change the sort order so I can view the
payment information by month in the short date format.
has the payment dates sorted by ascending date. I have an expression that
changes that date to mm-yy format (Format([pmtDate],"mm-yy").
The query results come out properly sorted but when I display the pivot
table, it wants to sort the dates alphabetically by month instead of
chronologically. Is this because the format expression is changing it into a
text format, and if so how can I change the sort order so I can view the
payment information by month in the short date format.