AnsweredAssumed Answered

Display most recent date from sub-set of dated records

Question asked by arronman on Apr 24, 2013
Latest reply on Apr 26, 2013 by philmodjunk

Title

Display most recent date from sub-set of dated records

Post

     Hello again. I have a table of records we'll call Visits, another table called Suburbs and a third called Shops. Visits, the master list,  contains records holding data of shops, suburbs, date(s) visited, and more. Every visit to every shop has its own record.

     The shops table (& layout) lists every shop with a portal  displaying data of each visit. Works fine.

     The Suburbs Layout displays the list of suburbs containing (or known to have no) shops.

     In the Suburbs layout, I need to display how many shops there are in each suburb, and another field displaying the date of the most recent visit that has been made to any shop in that suburb. Ideally I would have the latest visit date for each of the shops.

     As usual assistance would be greatly appreciated. Thanks.

Outcomes