Easy question about using group function on date.

[Guest]

I have a spreadsheet that has multiple dates in the feild, I would like to
just group the data together by month and do a count and a sum on two ther
feilds of data. I have tried to input MM in the format box which than shows
me just the month number but when I apply the group functions it still
recognizes the day because it doesn't group all of the month numbers
together. How do I fix this?

 

[Graham R Seach]

Dan,

Since you're talking about a spreadsheet, you might get more joy asking your
question in an Excel newsgrup. This one os for Microsoft Access, the
database management system.

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia

 

[Guest]

Sorry I guess I should have explained in more detail. I am trying to run a
query in acces from a link table. I don't want to change any of the data in
my excel spreadsheet but want to manipulate it to what I need in access. So I
am asking for help on how to do this in my Query in access.

 

[John W. Vinson]

I have a spreadsheet that has multiple dates in the feild, I would like to
just group the data together by month and do a count and a sum on two ther
feilds of data. I have tried to input MM in the format box which than shows
me just the month number but when I apply the group functions it still
recognizes the day because it doesn't group all of the month numbers
together. How do I fix this?

What you'll actually need to do is add a new column to the query. In a vacant
Field cell type either

MonthNo: Month([datefield])

if all of the dates are in one year, or

YearAndMonth: Format([datefield], "yyyymm")

if they span multiple years. Group By this field.

John W. Vinson [MVP]