AnsweredAssumed Answered

Data from last records in a group

Question asked by john9210 on Oct 17, 2012
Latest reply on Oct 17, 2012 by philmodjunk

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?

Outcomes