Conditional count of dates before deadline

[compliance data]

I am in the process of preparing compliance reports for a review cycle. An
important piece of information is whether or not compliance was reached
within 1 year of the audit. In the dB I have a range of dates when evidence
of compliance was submitted for each entity. What I would like to do is get a
count of compliance completed within the year for each entity.

I have tried count if and IIF statements without any success. I was able to
successfully apply conditional formatting to those dates that were > 1 yr due
date.

Thanks in advance for your thoughts

 

[Duane Hookom]

Could you share some field names? There should be some date fields that are
used to calculate overdue or whatever.

Generically, you can count the number of records in a report meeting a
specific condition with an expression like:
=Sum(Abs(...Your True/False Condition...) )

 

[compliance data]

The data field in the report is [datecompliancecorrected] I am attempting to
match/compare this to [1yrduedate]. does this help?

 

[Duane Hookom]

I don't know what your specific calculation would be:
Maybe:
=Sum(Abs(DateDiff("yyyy",[datecompliancecorrected],[qyrduedate])<=1 ) )
Or:
=Sum(Abs([datecompliancecorrected]<=[qyrduedate] ) )
Or:
=Sum(Abs([datecompliancecorrected]>[qyrduedate] ) )

--
Duane Hookom
Microsoft Access MVP
If I have helped you, please help me by donating to UCP
http://www.access.hookom.net/UCP/Default.htm

The data field in the report is [datecompliancecorrected] I am attempting to
match/compare this to [1yrduedate]. does this help?

Could you share some field names? There should be some date fields that are
used to calculate overdue or whatever.

Generically, you can count the number of records in a report meeting a
specific condition with an expression like:
=Sum(Abs(...Your True/False Condition...) )

--
Duane Hookom
Microsoft Access MVP
If I have helped you, please help me by donating to UCP
http://www.access.hookom.net/UCP/Default.htm

 

[compliance data]

Yes thank you here is the expression I used and it worked
=Sum(Abs([DateComplianceCorrected]<[1YrDueDate]))