quarterly reports in Access

[Guest]

Our fiscal year starts on 1st April each year. I want to produce quarterly
reports in June September December and March. How do I tell Access to start
calculating quarters from 1st April instead of 1st January (This is England,
UK, not USA).

 

[Guest]

Hi JayStar,

One way would be to have a report criteria form where you can select the
dates you want your report to run. Then have your query pick the dates up
for the where clause.

Hope this helps.

Damian.