On 15/05/2010 12:35, PieterLinden via AccessMonster.com wrote:
IIF(DateDiff("d", NextTestDate, Date())=7,"Out of Date Soon","OKAY")

This works ok, but for items that are well out of date, or past the
NextTestDate, they were shown as OKAY, So I removed that and now those
said items are showing as blank in an OutOfDate field I am using.

Is there a way of differentiating between items that are OKAY and those
that are out of date.

Thanks