I would like to group by a ParentID, then sort that group based on date.
I have name, title,ParentId,Date as fields in my query. What is the best access sql to do this?

What have just seems to order by date, not group the parentids, then order by date...

Thanks