Hi Evan

Thanks for the quick reply. The Max function in SQL doesn't operate like the xBase MAX() function. However, I will try the subselect idea.