Automatically Update Current Fiscal Quarter

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

Guest

I have a report that displays the current fiscal quarter. Right now I have to type in the correct quarter in the criteria section of one of my queries. I want the quarter to update automatically. I don't want to base the current quarter updates solely upon 2004 dates i.e. month and year, but on the month no matter what year it is.
 
-----Original Message-----
I have a report that displays the current fiscal
Click to expand...
quarter. Right now I have to type in the correct quarter
in the criteria section of one of my queries. I want the
quarter to update automatically. I don't want to base
the current quarter updates solely upon 2004 dates i.e.
month and year, but on the month no matter what year it
is.
.
Click to expand...

Use the function DatePart. DatePart("q", Date) returns
the numeric value of the current quarter regardless of
year. The 'Date' is really an Access function, Date(),
that returns the current date base on your PC's system
date.
To learn more about datepart, open a module in Access and
then click the Help button. This is Visual Basic help
instead of Access Help. Perform and index search on
Datepart.
 

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

End of Quarter Based on Fiscal Year 2
Date query, subtract 3 months 10
Criteria for results in report of previous year 5
How do I set the Fiscal Year in Access 2002? 5
How do I set the fiscal year? 2
Create an input form 4
Quarterly query 7
Quarterly report 2

Back
Top