Report grouped by year

[rebecca.dillard]

I have a report that gives totals by years. The year
runs from Jan 1 to Dec 31. However, I would like to
total to be grouped by fiscal year October 1 to September
30. Can anyone help?

 

[Duane Hookom]

Create a column in your query
FiscalYear: Year(DateAdd("m", 2, [YourDateField]) )

 

[rebecca]

-----Original Message-----
Create a column in your query
FiscalYear: Year(DateAdd("m", 2, [YourDateField]) )

message news:[email protected]...


.
Thanks, that worked. Can you explain the expression to

me?

 

[Duane Hookom]

The expression adds two months to the date and then finds the year of the
new date.

--
Duane Hookom
MS Access MVP

-----Original Message-----
Create a column in your query
FiscalYear: Year(DateAdd("m", 2, [YourDateField]) )

message news:[email protected]...


.
Thanks, that worked. Can you explain the expression to

me?