Hi Elaine
Try This, First you must have a table or create with the following fields: a)
Name of Employee b) Seniority Date c) DateEvalRcvd enter necessary data, then
create a query based on that table. On query design insert or add column then
type DueDate:DateAdd("m",1,[SeniorityDate]) then add another column type
Remarks:IIf([DateEvalRcvd]<=[DueDate],"On Time","Late") add another column type
DaysLate:IIf([Remarks]="Late",DateDiff("d",[DueDate],[DateEvalRcvd]))
Good Luck,
Romeo
[Non-text portions of this message have been removed]
