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