AnsweredAssumed Answered

Layout based on LAST record based on Field in table

Question asked by gregcaine on Jul 2, 2012
Latest reply on Jul 5, 2012 by gregcaine

Title

Layout based on LAST record based on Field in table

Post

I can't quite figure out how to get ONLY the last record from a quotes table. I only want to see the most recent record for each unique email address. For example, a quote can be generated 7 times by an individual - I ONLY want to view the most recent quote (i.e., max system generated numeric auto id). Additionally, I filter the table for the entire day so there can be dozens of unique email addresses in the results view.

I am used to using grouping functions dynamically when using an ACCESS form. How do I efficiently use a relationship (or calculated field) for my Layout source? 

Outcomes