How to find the latest row for each group of data
- by Jason
Hi All,
I have a tricky problem that I'm trying to find the most effective method to solve.
Here's a simplified version of my View structure.
Table: Audits
AuditID | PublicationID | AuditEndDate | AuditStartDate
1 | 3 | 13/05/2010 | 01/01/2010
2 | 1 | 31/12/2009 | 01/10/2009
3 | 3 |…