Multiple Query Criteria

[Dan Sweetwood]

I need a report query to filter using multiple criteria for medications
scheduling that returns only current medications. Often we have to enter in
medications to begin on future dates and for the medications to end on a
future date. What I have works great except for medications that will start
after today and the DC (Discontinued) date field is empty. Here is what I
have now:

Field Col Field Col
StartDate (Current or future start date) DCDate(Discon. or to be discon.
date)
Criteria: <=Date() >Date()
Is Null

Hope that is enough info. Your assistance is greatly appreciated!

 

[Van T. Dinh]

I am not sure about the terms you use: If you are interested in the CURRENT
medication, the a medication to be started in the (near) future is not
current, is it?

OTOH, if you are interested in inboth current and near-future medications,
then I guess you can simply remove the criteria from the StartDate column?

 

[Dan Sweetwood]

Current medications are only those that startdates are equal to today or less
that have not been discontinued. So what can I do to get it to filter based
on that criteria?

 

[Van T. Dinh]

Put Is Null in the SAME criteria row as > Date and join them by OR, i.e.

DCDate column
Is Null Or > Date().

 

[Dan Sweetwood]

Something so simple! Thank you very much!
--
Dan S

Put Is Null in the SAME criteria row as > Date and join them by OR, i.e.

DCDate column
Is Null Or > Date().

 

[Van T. Dinh]

You're welcome ... Glad to help ...