I struggled to find an example of what I was trying to do, so I thought I would post here.  I borrowed some from this site, but it didn't quite do what I wanted and my tables weren't split up the way the author had it.

Basically I have a table in Access 2007 that contains a column for the venue location, a column for the monthly revenue, and a column for the date (month, last day of the month, and year).  I needed a quick way to sumarize the data by financial year.  The financial year in this case runs from July 1st to June 30th.   Here is the completed query.

 SELECT [Table1].[IDColumn],  Year([Table1].[DateColumn])  & "-" & (Year([Table1].[DateColumn]) +1) As FinancialYear, (SELECT SUM([Table2].[MonthlyRevenue]) as FYTD
FROM [SomeTable] AS Table2
WHERE [Table2].[DateColumn] >= DateSerial(Year([Table1].[DateColumn]),7,1)               
     AND [Table2].[DateColumn] <= DateSerial(Year([Table1].[DateColumn])+1,6,30)
AND [Table2].[Venue_ID] =  [Table1].[IDColumn];) AS Rev_Value_Year

FROM [SomeTable] AS Table1
Group By [Table1].[Venue_ID], Year([Table1].[DateColumn]) , Year([Table1].[DateColumn])  & "-" & (Year([Table1].[DateColumn]) +1) ;

Basically i used a subquery to calculate the total for that financial year.  I'm not quite sure why, but I need to group by the year as well as the Financial Year.  I genericized the table and column names.  Hope that helps someone else with the same problem.