If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
access crosstab queries month range
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. |
#3
|
|||
|
|||
access crosstab queries month range
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. |
Thread Tools | |
Display Modes | |
|
|