Grouping data by fiscal year not calendar year

[Ted Hall]

I would like to total data in a query by our fiscal year
(July 1 thru June 30)and not by calendar year. How could
I do this?

 

[David Wilson]

In your query create a new field with a function for the fiscal year. I will
assume you have a date field of date/time type named [date1].

fiscal_year: iif(month([table_name].[date1]) > 6,
year([table_name].[date1]), year([table_name].[date1]) - 1)

The above assumes that 7/1/2003 is in fiscal year 2003. Reference the
functions iif, month, and year to learn more.