gojets1721
Registered User.
- Local time
- Today, 00:50
- Joined
- Jun 11, 2019
- Messages
- 430
See the attached DB. I have really specific DCount question.
In the complaintfollowup field, users input dated notes and each note is separated by a line break. I'm trying to figure out a way to capture the number of records via DCount where the very last dated note in any given record is older than 30 days and the complaint status is 'open'. In my example, it would show one record.
Any suggestions?
In the complaintfollowup field, users input dated notes and each note is separated by a line break. I'm trying to figure out a way to capture the number of records via DCount where the very last dated note in any given record is older than 30 days and the complaint status is 'open'. In my example, it would show one record.
Any suggestions?