If it is a date/Time field then I assume it contains the year so if you want
the data for the second quarter of FY 07 then look for dates Between
#1/10/07# and #31/12/08#




"reterrig" wrote in message
...
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