Current Quarter Query

[oscarbrown4]

Ok... I need a query to only show the dates from the current quarter
from a table called "tblWeeklyFigures" and the field "Week Ending
Date". How would I go about doing this? Do I need to create a module
or can I do this from the "Week Ending Date" criteria in the query? I
have Access 2007 beta and Access 2004. I've read countless messages on
using the DatePart function and how to only show this current quarter
but I guess I'm still stumped. Any help would be greatly appreciated!
Thanks,
Oscar

 

[Marshall Barton]

Ok... I need a query to only show the dates from the current quarter
from a table called "tblWeeklyFigures" and the field "Week Ending
Date". How would I go about doing this? Do I need to create a module
or can I do this from the "Week Ending Date" criteria in the query? I
have Access 2007 beta and Access 2004. I've read countless messages on
using the DatePart function and how to only show this current quarter
but I guess I'm still stumped.

Create your new query based on the tables/queries that
provide the information you want in the report. Then add a
calculated field:

Qtr: DatePart("q", [Week Ending Date])

so you can set its criteria to 1,2,3,4 to choose the desired
quarter. If you want the quarter for the current date that
the report is printed, use the criteria:
=DatePart("q",Date())