Dates: Month and Year

[Guest]

Hello,

Is there a way to group records by month and year in the same column. I can
do it in two using date part but I would prefer to be able to do it in one
column.

Thanks

 

[Allen Browne]

Try:
Format([MyDate], "yyyymm")

Access considers the result to be text.

 

[Guest]

Cheers

Try:
Format([MyDate], "yyyymm")

Access considers the result to be text.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

Is there a way to group records by month and year in the same column. I
can
do it in two using date part but I would prefer to be able to do it in one
column.