2 Replies Latest reply on Oct 17, 2012 8:55 AM by philmodjunk

    Data from last records in a group

    john9210

      Title

      Data from last records in a group

      Post

           FM 11 Adv. I’m looking for a way to extract data from the last record in each group of records in a child table.

           For example: A table Author has author names and the child table Book has the books written by each author. How can I create a report that contains only the name of the last book published by each author?