date posted 4th September 2007 17:22 Thanks Dai / Gidon. I added ... GROUP BY tblCourses.ID ... and it's behaving how I want.