Grouping using 2-3 criteria

[Guest]

I am fairly new to access and Just got a report dumped on me. Basically I am
runnig a report on failures over the course of 3 years by month.
Example
I have I want
Year Month Part number Year Month Part number failures
1 1 a 1 1 a
2
1 1 a 1 1 b
1
1 1 b 1 2 a
2
1 2 a 2 1 b
1
1 2 a
2 1 b

I think that expalins it. How do I make a query to group like that or is it
possible. Like I said I am fairly new to this and don't have the time to
read up on it as the report is due at the end of the week. Thanks in advance
for any help. I will be chacking back frequently so if you require a better
explanation or more infor feel free to ask.

 

[Guest]

Should also note that I am using Microsoft Access 2003.

 

[Guest]

Try this --
SELECT Jedi.Year, Jedi.Month, Jedi.[Part number], Count(Jedi.[Part number])
AS Failures
FROM Jedi
GROUP BY Jedi.Year, Jedi.Month, Jedi.[Part number];