Group by using Date field

[Mark R.]

Is there an expression I can use to group by using a Date
field that will group using only the Month and Year (not
the day)? Also can it be done using one field rather than
splitting them into two?

Thanks!

 

[Angie]

-----Original Message-----
Is there an expression I can use to group by using a Date
field that will group using only the Month and Year (not
the day)? Also can it be done using one field rather than
splitting them into two?

Thanks!
.
Here is how I do it. Create a field in the query with the

following expression. CDate(Format(

![field
name], "mm/yyyy")) You will be able to group by that and
it will be in date format.