Query Criteria to X Quarter of Y Year

[Ksel]

Hi All,

I have a form (frmMetrics) with 2 Combo Boxes: "Year" and "Quarter" These are just number fields (which might be my problem?)

I have a date/time field in a query, and I want the criteria to be based off the year and quarter selected in frmMetrics.

Seems simple, but I can't seem to figure it out. Any help appreciated!

Thanks,
Kevin

 

[vbaInet]

You can use the Year() and DatePart() functions for the Year and Quarter parts of the criteria.

Here's a link:
http://www.classanytime.com/mis333k/sjdatetime.html

 

[Ksel]

Hey vbaInet,

Until just recently, I never had a chance to get around to this after I posted. Thanks for the response! Yea I ended up just making some extra fields in a query with the DatePart function, and got it figured out with your help.

Thanks much,
Kevin