Sortyerd Report with totals

[snifferpro]

I have a table (HoursTable) with 3 fields


(DATE LOCATION HOURS)
( Date/Time Text Number)

I want to produce a report sorted by Year and Month
with totals of HOURS for each Year and Month, a subtotal for year,
and a final total of HOURS at the end.

It would look like this;

HOURS WORKED

Year & Month Hours

2010 - 1 88
2010 - 2 99
2010 - 3 99
2010 - 10 5

Total for 2010 291


2011 - 1 77
2011 - 2 98

Total for 2011 175


2012 - 1 20
2012 - 2 30

Totals for 2012 50



Total Hours 516


I tried using the report wizard and I got this;
Yearly/Monthly Totals

Year - Month Hours

2010 - 1 88
2010 - 10 5 This should be after 2010-3
2010 - 2 99
2010 - 3 99
2011 - 1 77
2011 - 2 98
2012 - 1 20
2012 - 2 30

_______________________516

The Query for this is;

SELECT Year([HoursTable].[DATE]) & "-" & Month([HoursTable].[DATE])
AS YearAndMon,
Sum(HoursTable.HOURS) AS SumOfhours
FROM HoursTable
GROUP BY Year([HoursTable].[DATE]) & "-" & Month([HoursTable].[DATE]);



How do I do this in Access 2007.

I am a rookie at this so specific examples would be very
helpful.



Thanks In Advance

[June7]

Problem is the Year - Month values are text not numeric so 10 sorts before 3. Need placeholder zero in the month.

Year([HoursTable].[DATE]) & "-" & Format([HoursTable].[DATE],"dd")

Use report Grouping & Sorting with aggregate calcs in footer textboxes. Access Help has guidelines on building this type report.