Create Yearly Report 1

[AndyApp]

I have a table that is holding the date that a job was submitted in the format DD/MM/YY in a field called DateSubmitted.

I have now been given the task of creating a report that will show all the months of the year and then a score (I can do the score bit), however i'm holding jobs by a specific date not just a month so I don't know how to create a query that a report can look at that will take these scores and add them together for the entire month.

How can I get all these dates to just be in their respective months. e.g. all the DD/01/03's together and all the DD/02/03's together etc, etc

"Life is like a Ferrari, it goes to fast.
But that's ok, because you can't afford it anyway" - Jim Davis (Garfield)

 

[YenRieur]

personnaly, I create a new colonn in my query
where my reports looks :

DateYYMM:format([DateWeAreTalkingAbout];"yymm&quot

and then in the report, you can group by dateYYMM

(parts of my Access are in french,
so translation of functions can be a little diffrent
;p

 

[AndyApp]

Cheers YenRieur.

The british way is:
DateYYMM: Format([DateSubmitted],"mmyy&quot

Just slightly different.

Thanks again

"Life is like a Ferrari, it goes to fast.
But that's ok, because you can't afford it anyway" - Jim Davis (Garfield)