Edit Date Range On A CrossTab Query

Hi have a table tblImportLearnerFunding with the fields [LCCode], [Date] and [Total Learner Funding]

I want to create a table to see the funding generated for each LCCode in custom date ranges:
LCCode, DateRange1, DateRange2, DateRange3

I can almost get it to work using the crosstab query wizard, but I need to specify the date ranges. Instead of Jan I want to sum the funding in the date range 01/01/2005 to the 28/01/2005 and so on.... Does anyone have any clues?


Here's the Crosstab SQL:

TRANSFORM Sum(tblImportLearnerFunding.[Total Learner Funding]) AS [SumOfTotal Learner Funding]
SELECT tblImportLearnerFunding.LCCode, Sum(tblImportLearnerFunding.[Total Learner Funding]) AS [Total Of Total Learner Funding]
FROM tblImportLearnerFunding
GROUP BY tblImportLearnerFunding.LCCode
PIVOT Format([Date],"mmm") In ("Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec");