Month() returns only Jan or Feb

C

Chris Sergent

Gwen,
You just have to make a simple change it appears:
If your field is [servicedate], write this in the query:
Month Started:Format([servicedate],"mmmm")

This should give you the months. Also make sure you are
not using any criterias within the query that might cause
data to be excluded.

Chris
-----Original Message-----
Please help.
I want to group employees by the month of their service
Click to expand...
date independent of the year of service.
Everyone who started in January, February and so on. I do not care about the year.
The result I am getting is grouping the employees by
Click to expand...
month based on the year of service. So, I getting several
Januarys, February and so on.
Also, I have tried using format(month
Click to expand...
([servicedate]), "mmmm") in the query and report, but it
returns January or December.
 
Top