Well, it does remove the code error I was having, however the query that I am using (based on PEB's Sept 21st post) displays an error in the ranking field of every record:

Query -
Ranking:IIF(Sho w_last_criteria ([Your_Field])=[Your Field with Criteria],Set_last(nz(Sh ow_last([Your Field with Criteria]))+1, [Your Field with Criteria]),Set_last(1, [Your Field with Criteria]))

My query looks at EmpID, Date, Score,...

I have copied these functions into a module but I get an error that the nts(criterias) function is not defined.

Did I miss something?

Thanks...Wm...