Crosstab Query - Group by Month and Year

"sakura" wrote in
:

Crosstab Query - Group by Month and Year
"inesv" wrote in message
... Pouvez vous parlez en français
!!!

Yes I can but not here. This is an International group discussing the
Microsoft Access database program..



Le 13/03/10 17:02, dans ,
« Bob Quintal » a écrit :

"Duane Hookom" wrote in
:

It might be marginally faster but I doubt you could tell
unless your data set is huge. My suggestion will format Jan as
01 with the leading 0. This will sort the columns from left to
right as you would expect to see them 2009-01,
2009-02,...2009-12 rather than 2009-1, 2009-10, 2009-11,...
2009-9.


right.


------=_NextPart_000_003B_01CAC823.365EBF30
!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"
HTMLHEADTITLE Crosstab Query - Group by Month and
Year/TITLE META content=text/html;charset=iso-8859-1
http-equiv=Content-Type META name=GENERATOR content="MSHTML
8.00.7600.16490"/HEAD BODY style="PADDING-LEFT: 10px;
PADDING-RIGHT: 10px; PADDING-TOP: 15px" id=MailContainerBody
leftMargin=0 topMargin=0 CanvasTabStop="true" name="Compose
message area" DIV /DIV
BLOCKQUOTE
style="BORDER-LEFT: #000000 2px solid; PADDING-LEFT: 5px;
PADDING-RIGHT: 0px; MARGIN-LEFT: 5px; MARGIN-RIGHT: 0px" dir=ltr
DIV"inesv" <A
/A> wrote in message
A
"news:C7C98AB 4.6DB%inesv@sfr
.fr/A.../DIV P align=centerFONT color=#800080FONT
size=6FONT face="Helvetica Neue UltraLight"SPAN
style="FONT-SIZE: 24px"BPouvez vous parlez en français
 !!! /B/SPAN/FONT/FONT/FONT PFONT
face="Verdana, Helvetica, Arial"SPAN style="FONT-SIZE:
12px"BRBRLe 13/03/10 17:02, dans
, « Bob
Quintal » > a
écrit :BRBRFONT color=#0000ff> "Duane Hookom"
> wrote inBR>
:
BR> BR/FONTFONT color=#008000>> It might be
marginally faster but I doubt you could tell unlessBR>>
your data set is huge. My suggestion will format Jan as 01
withBR>> the leading 0. This will sort the columns from
left to right asBR>> you would expect to see them
2009-01, 2009-02,...2009-12 ratherBR>> than 2009-1,
2009-10, 2009-11,... 2009-9. BR>> BR/FONTFONT
color=#0000ff> BR>
right.BR/FONT/SPAN/FONT/P/BLOCKQUOTE/BODY/HTML

------=_NextPart_000_003B_01CAC823.365EBF30--



--
Bob Quintal

PA is y I've altered my email address.

"ëÏÒÎÅÊÞÕË"
ÓÏÏÂÝÉÌÁ ÓÌÅÄÕÀÝÅÅ:
"ðÒÅÉÍÕÝÅÓÔ×Á É ÎÅÄÏÓÔÁÔËÉ ×ÙÓÛÉÈ ÕÞÅÂÎÙÈ ÚÁ×ÅÄÅÎÉÊ Ç.íÉÎÓËÁ"
ñ ÄÕÍÁÀ, ÞÔÏ ÌÕÞÛÉÊ ÓÁÊÔ Õ âçõ!!!!!!!!!!
"Bob Quintal" ÓÏÏÂÝÉÌ/ÓÏÏÂÝÉÌÁ × ÎÏ×ÏÓÔÑÈ
ÓÌÅÄÕÀÝÅÅ: ...
"sakura" wrote in
:

Crosstab Query - Group by Month and Year
"inesv" wrote in message
... Pouvez vous parlez en français
!!!

Yes I can but not here. This is an International group discussing the
Microsoft Access database program..



Le 13/03/10 17:02, dans ,
« Bob Quintal » a écrit :

"Duane Hookom" wrote in
:

It might be marginally faster but I doubt you could tell
unless your data set is huge. My suggestion will format Jan as
01 with the leading 0. This will sort the columns from left to
right as you would expect to see them 2009-01,
2009-02,...2009-12 rather than 2009-1, 2009-10, 2009-11,...
2009-9.


right.


------=_NextPart_000_003B_01CAC823.365EBF30
!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"
HTMLHEADTITLE Crosstab Query - Group by Month and
Year/TITLE META content=text/html;charset=iso-8859-1
http-equiv=Content-Type META name=GENERATOR content="MSHTML
8.00.7600.16490"/HEAD BODY style="PADDING-LEFT: 10px;
PADDING-RIGHT: 10px; PADDING-TOP: 15px" id=MailContainerBody
leftMargin=0 topMargin=0 CanvasTabStop="true" name="Compose
message area" DIV /DIV
BLOCKQUOTE
style="BORDER-LEFT: #000000 2px solid; PADDING-LEFT: 5px;
PADDING-RIGHT: 0px; MARGIN-LEFT: 5px; MARGIN-RIGHT: 0px" dir=ltr
DIV"inesv" <A
/A> wrote in message
A
"news:C7C98AB 4.6DB%inesv@sfr
.fr/A.../DIV P align=centerFONT color=#800080FONT
size=6FONT face="Helvetica Neue UltraLight"SPAN
style="FONT-SIZE: 24px"BPouvez vous parlez en français
 !!! /B/SPAN/FONT/FONT/FONT PFONT
face="Verdana, Helvetica, Arial"SPAN style="FONT-SIZE:
12px"BRBRLe 13/03/10 17:02, dans
, « Bob
Quintal » > a
écrit :BRBRFONT color=#0000ff> "Duane Hookom"
> wrote inBR>
:
BR> BR/FONTFONT color=#008000>> It might be
marginally faster but I doubt you could tell unlessBR>>
your data set is huge. My suggestion will format Jan as 01
withBR>> the leading 0. This will sort the columns from
left to right asBR>> you would expect to see them
2009-01, 2009-02,...2009-12 ratherBR>> than 2009-1,
2009-10, 2009-11,... 2009-9. BR>> BR/FONTFONT
color=#0000ff> BR>
right.BR/FONT/SPAN/FONT/P/BLOCKQUOTE/BODY/HTML

------=_NextPart_000_003B_01CAC823.365EBF30--



--
Bob Quintal

PA is y I've altered my email address.