Format a report from form/subform

[bellemmar]

I have a form with a subform with parent/child linked fields called ID.

I want to format a report that shows all of the parent form fields but only the MOST RECENT of each of the numerous child entries.

For instance, in the parent form, the record entry is called Goal 1 and the subform contains many entries under this goal. But I only want the report to show the most recent of those entries rather than all of them (which it's currently doing).

Help!

 

[vbaInet]

1. Sort the query behind the subform in Descending order by whatever field that determines it as the latest record. I assume this would be an auto generated ID or a date/time stamp.
2. Use the TOP predicate in the SQL of the query to show only the first record. i.e.

SELECT [COLOR=Red]TOP 1[/COLOR] Field1, Field2, Field3 
FROM TableName

 

[bellemmar]

And if I don't have a query behind the subform?