Criteria for results in report of previous year
My table includes only field with the Date/Time
"KC-Mass" wrote:
Does your table not include a field with the FiscalYear??
"reterrig" wrote in message
...
I have created an account file for a fiscal year that begins 1st July and
ends 30th June of the next Year.
I Need a report for each quarter separately. My Table "Accounts" has a
field "Accountsdate". In the relevant query of the report "First Quarter"
in
the Criteria of the field "Accountsdate" I have inserted
"[Accounts].AccountsDate Between 1/10 And 31/12".
Report only shows the results of the dates between 1/10 and 31/12 but of
the
present year.
I need the report to show results of the quarter of the previous year
|