Adding Conditional Date to Report

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

Guest

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!
 
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".
 
That worked great. Thanks so much!

Allen Browne said:
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".
Click to expand...
 
Back
Top