Adding Conditional Date to Report

[AuditorCMM]

We are setting up a database to log all employee compliants. On one of our
summary reports, we want to add a section that shows the date of the oldest
compliant that is still under investigation. We do have a field in the
database that indicates whether or not the compliant has been resolved, so I
know we need to base the formula on whether that is yes or no, but how do I
develop a formula that pulls the oldest date? I'm afraid there is no simple
way to do this!

Any help would be appreciated. Thanks!

 

[Allen Browne]

Set the Control Source of your text box to something like this:
=DMin("ComplaintDate", "tblComplaint")

Use your field name instead of "ComplaintDate", and your table name instead
of "tblComplaint".

 

[AuditorCMM]

That worked great. Thanks so much!

Set the Control Source of your text box to something like this:
=DMin("ComplaintDate", "tblComplaint")

Use your field name instead of "ComplaintDate", and your table name instead
of "tblComplaint".