comparing multiple records

Question

I am trying to look at a group of records for an individual and return when their next recertification is due. Currently I have records for each recertification and when the next is due. However, when they are recertified it may be for more than one type and the expiration dates may not all be the same. What I would like to do is look back through their records and determine when the next certification is due and return just that due date, so I can see a list of all employees and when their next certification is due.

quickbasecoachd · Answer

Assuming that the certification records have a field for [Date Completed], then it would just be a summary field on a relationship where 1 employee has many certifications, and it would be a summary minimum of the Certification Due Date where the [Date Completed] is blank.

dantetognoli · Answer

I'll give that a shot, Thanks.

Forum Discussion

comparing multiple records

Related Content

Using Grid Edit to Edit Multiple Records at Once

Edit Multiple Records at Once with Grid Edit

Modify multiple rows within the same group using Single Record ?

Jinja Expression Comparing Now to Now+Hours

Custom Record Titles