financial year

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

how do i get access to only return results within the financial year (April -
march), i have a field registrationDate which is where i would presume the
criteria would be based. i would want the query to automatically change with
each year so in 2005/06 it would display the 2005/06 results however in
2006/07 it would be 2006/07 results

thanks for any help

Phil
 
This will convert your dates to financial years.
DatePart("yyyy",DateAdd("m",-3,[YourDate]))
Just enter a four digit year as criteria.

This will give you the current financial year.
DatePart("yyyy",DateAdd("m",-3,Date()))
 
Karl thanks a lot that worked great

Phil

KARL DEWEY said:
This will convert your dates to financial years.
DatePart("yyyy",DateAdd("m",-3,[YourDate]))
Just enter a four digit year as criteria.

This will give you the current financial year.
DatePart("yyyy",DateAdd("m",-3,Date()))


Phil said:
how do i get access to only return results within the financial year (April -
march), i have a field registrationDate which is where i would presume the
criteria would be based. i would want the query to automatically change with
each year so in 2005/06 it would display the 2005/06 results however in
2006/07 it would be 2006/07 results

thanks for any help

Phil
Click to expand...
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Append query 1
Financial Years 1
referencing dates 4
How to convert date to financial year format 2006-07 4
Year-over-Year Comparisons 1
copy drag financial years 3
Dates 4
Pivot Table by Financial Year 2

Back
Top