Date Criteria

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello Everyone
I have an aggregate reprot that covers three different times (3months, 6 months, 12 months) that is published monthly. Here is an example of one of the functions I use
=dcount("[RecordID]", "qryOutcomeEvalAuditMaster", "[Follup3Mo]<>Null"). This just says to count the records if the Followup Date is not empty. What I want is to have the followup Date month equal today's month. I really appreciate your help.
 
Hello Everyone!
I have an aggregate reprot that covers three different times (3months, 6 months, 12 months) that is published monthly. Here is an example of one of the functions I use:
=dcount("[RecordID]", "qryOutcomeEvalAuditMaster", "[Follup3Mo]<>Null"). This just says to count the records if the Followup Date is not empty. What I want is to have the followup Date month equal today's month. I really appreciate your help.
Click to expand...

Well, this won't correctly handle the NULL - nothing is either equal
OR unequal to NULL.

Instead, use a criterion of

"Month([Follup3mo]) = Month(Date()) + 1)"

assuming that Follup3mo is a Date/Time field. If it's NULL the
criterion will return false anyway.
 
Back
Top