access crosstab queries month range

I am working on putting together crosstab pivot queries by month.

It always goes by calendar month order:
Jan, Feb, Mar, etc.

How do I set up the columns so they are in sequential order I want,
with the year, ex:

Dec 07, Jan 08, Feb 08, etc.

You have two choices, neither get you exactly what you want.
PIVOT Format([YourDateField, "mmm yy") IN("Dec 07", "Jan 08", "Feb 08",
etc. );
AND update it every month.

OR
PIVOT Format([YourDateField, "yy mm mmm");

--
KARL DEWEY
Build a little - Test a little


" wrote:

I am working on putting together crosstab pivot queries by month.

It always goes by calendar month order:
Jan, Feb, Mar, etc.

How do I set up the columns so they are in sequential order I want,
with the year, ex:

Dec 07, Jan 08, Feb 08, etc.

If your final destination is a report, consider the solution at
http://www.tek-tips.com/faqs.cfm?fid=5466.

--
Duane Hookom
Microsoft Access MVP


"KARL DEWEY" wrote:

You have two choices, neither get you exactly what you want.
PIVOT Format([YourDateField, "mmm yy") IN("Dec 07", "Jan 08", "Feb 08",
etc. );
AND update it every month.

OR
PIVOT Format([YourDateField, "yy mm mmm");

--
KARL DEWEY
Build a little - Test a little


" wrote:

I am working on putting together crosstab pivot queries by month.

It always goes by calendar month order:
Jan, Feb, Mar, etc.

How do I set up the columns so they are in sequential order I want,
with the year, ex:

Dec 07, Jan 08, Feb 08, etc.