Hi

>If you're using list of fileds in the GROUP BY clause, you should also list them in SELECT field list. Otherwise adding new field to the table will brake your select. Alternatively, you can wrap fields that have the same value in a group in MIN() or MAX() instead of grouping on them. Even better, you can get key filed first and than join back to the table to get all fields including memo. SOmething like ( not tested)

Now that is an idea!!! Thanks a lot. I will test it.