Filtering data by date range (but excluding YEAR)

  • Thread starter Thread starter KK
  • Start date Start date
K

KK

I have a bunch of dates. I just want to pull everything from January
to March (1st quarter) but doesn't care about year.

I will be selecting a Year from a combo box, filtering all the
appropriate data. Then I want to look at all the dates and pick out
only the ones from January to March.

How do I do this?

Or have I answered my own question already?
 
Add an output field in query design view like this ---
Expr1: Format([YourDateField],"q")
Use the numerial for the quarter as criteria -- 1 for first quarter.
 
Let me try this,thanks.

Is there a good site I can read more about these date formats?

Add an output field in query design view like this ---
Expr1: Format([YourDateField],"q")
Use the numerial for the quarter as criteria -- 1 for first quarter.
--
KARL DEWEY
Build a little - Test a little



KK said:
I have a bunch of dates. I just want to pull everything from January
to March (1st quarter) but doesn't care about year.
Click to expand...
I will be selecting a Year from a combo box, filtering all the
appropriate data. Then I want to look at all the dates and pick out
only the ones from January to March.
Click to expand...
How do I do this?
Click to expand...
Or have I answered my own question already?- Hide quoted text -
Click to expand...

- Show quoted text -
Click to expand...
 
Back
Top