Need to query two date fields

[Klssri]

I have a simple database I am working on, but need some help pulling out some information. We want to be able to pull records for clients whose case was open during a specific quarter and/or fiscal year, using a parameter. We have a case opening date field and a case closing date field. We want to see all cases that were open during the quarter, Case Closing date would be null, and all cases that closed during the quarter. I think I could use an iff statement to do this, but not sure. Also where would I put the parameter as the case could have actually opened before the start of the quarter, so I really can't use case open date. Is there a way to do this? (if this makes any sense).

 

[Golom]

You probably need multiple conditions in the WHERE clause

PARAMETERS [Enter The Year] Integer, [Enter The Quarter] Integer;

SELECT ...
FROM ...

WHERE
   10*Datepart("yyyy",[OpenDate]) + DatePart("q",[OpenDate]) <= 
   10*[Enter The Year] + [Enter The Quarter]

   AND 

   (10*Datepart("yyyy",[CloseDate]) + DatePart("q",[CloseDate]) >= 
    10*[Enter The Year] + [Enter The Quarter]
    OR [CloseDate] IS NULL)