I figured out with some help how to get the results set correct with a hard-coded date, but now I'm stuck on how to get the proper dates plugged into the query. The project is confidential, otherwise I'd post it. I have a year selection and a month selection on a form. Year selections is in YYYY format. Month selection is in MMMM format.
If the user selects "2010" and "December", I'd like the following to happen:
Code:
CaseStatus ReceivedDate Closed Date
------------------------------------------------------
<> Closed <#1/1/2011#
Closed >#12/31/2010#
I'm having trouble building the section in the query that would allow for this. I'm open to writing a custom function to make it happen, but my programming skills are somewhat lacking in this area.