T Ted Hall Nov 25, 2003 #1 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?
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 Nov 26, 2003 #2 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.
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.
