Date Queries

[StephenD]

Hi Everyone,

I think this will be an easy question......
I have a database for a membership programme and fields include join date and cancelled date. I want to count how many members have joined by month and members cancelled by month. I've done a simple Group by query, however the date fields include the day and for this query I only want to see the data by month. I've tried formatting the field to just show the month and year, however this still returns the data as seperate rows for each day. I also know there is a date part function, but that only lets you take one part at a time-so I would need seperate fields for month and year, then would have to somehow combine them back together again.
Is there an easier way??

Thanks!

StephenD

 

[Geoff Codd]

you need to create a field in the column with the following formula

Month: Format([Date Joined or what evver you have called it],"mm/yy")

this will now convert the date joined to just month and year and now you can group that column.

Just repeat for date cancelled

 

[StephenD]

Thanks very much-I'll try this out!