Layout based on LAST record based on Field in table
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?