|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
May 8th, 2009, 10:35 AM
posted to microsoft.public.access
|
|||
|
|||
Criteria for results in report of previous year
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 
|
| Thread Tools | |
| Display Modes | |
|
|
Threaded Mode