I am tracking 5 training dates. Four of which need to be three years or younger to be valid, the other must be less than a year old to be valid. A sixth field is a “Yes” or “No” parameter, “Yes” being valid. I need all six of these fields to be valid in order to identify the individual as "eligible". Is there a way to populate a field (an IIF statement maybe or macro) in this table to show all six fields as valid automatically?