Ok I am using Access to get data from 375,000 records. I know I have 23,000 unique people associated with the records. columns A,B,C,D are all static information about the person. I also have a date last seen which I want to use the max date.
How do I use the max of the date to find the latest instance of the complete record. Every time I try to use the max date and include any column F,G,H, I it gives me all of the records.
I have searched and I can't quite tie the answers to my data.
I have a unique id column (A), person ID column (B), and a date last seen column (E), I can't figure out how to get the max date (E) and still include the (A) to let me join to the rest of my data.