Summary Query Problem

  • Thread starter Thread starter Mike Ring
  • Start date Start date
M

Mike Ring

I have a query which takes a crosstab query and totals up
each column by month and year, so it looks like:
x y z a b c
April 99 2 0 10 5 0 21
May 99 1 4 6 2 0 54

And so on.

My problem is that once I get a certain number of columns
that I'm trying to sum up, it no longer sorts the months
by date, so the order is alphabetical by month, and looks
something like:

April 99
April 00
April 01
December 99
February 99
February 00
March 99
March 00

Any ideas on how to order it by date? I can post SQL if
needed.

Mike
 
At some point, you converted your date values to month/year format,
probably using the format command, and Access is just sorting
alphabetically.

You need to add another column to your query to sort appropriately.
You can eliminate the column in your form or report.

SortOrder: CDATE("1 " & [datefield])
Total:Group By
Crosstab:RowHeading.
Sort:Ascending

--
HTH

Dale Fye


I have a query which takes a crosstab query and totals up
each column by month and year, so it looks like:
x y z a b c
April 99 2 0 10 5 0 21
May 99 1 4 6 2 0 54

And so on.

My problem is that once I get a certain number of columns
that I'm trying to sum up, it no longer sorts the months
by date, so the order is alphabetical by month, and looks
something like:

April 99
April 00
April 01
December 99
February 99
February 00
March 99
March 00

Any ideas on how to order it by date? I can post SQL if
needed.

Mike
 
Back
Top