Grouping data by fiscal year not calendar year

T

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?
 
D

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.
 
Top