Torgny,

in my view this cannot work, because the SQL command won´t know what to put into the regdate column. That´s why the group by clause must include all columns of your table.

I think this was a bug in all VFP versions before :-)

...gerhard...