I was reviewing this need once again and find myself on a database that does not support subqueries and cannot get it upgraded at this time.

I have spent the last...

That is exactly right. With the query as it was it only returned 24 rows with a count of 1 for each. The union all did the trick...

quote:

---

Perhaps something like this?

SELECT c.Item_No, c.Item_YesNo, c.Item_Date

FROM CheckList c JOIN

(SELECT Item_No, MAX(Item_Date) Item_Date

 FROM Checklist

 GROUP BY Item_No)...