I have very little Access experience, but I know this can be done.. just not how.
My table has 14 columns
-ID, Company Name, Agency ID, Last Name, First Name, Middle Initial, Field 8, Optional 1, Optional 2, Date Submitted, coursed, Course Status, Last Accessed
ID, Company Name, Agency ID, Last Name, First Name, Middle Initial, Field 8, Optional 1, Optional 2, and Date Submitted stay the same for a particular set (???). For example:
ID - 1
Company Name - Smallville
Company ID - 111
Agency ID - 00000012345
Last Name - Washington
First Name - George
Middle Initial - (none)
Field 8 - wash1234
Optional 1 - (none)
Optional 2 - (none)
Date Submitted - 30-Apr-2013
courseid - Course
Course Status - Completed
Last Accessed - 28-Jul-08
The differences are in courseid, Course Status, and Last Accessed are generally different.
George Washington has 7 lines of data, while Ronald Reagan has 2 lines of data and Lincoln could have 5. I am working with a total of about 2000 names with each have multiple entries. I need to sort my data to keep the newest Last Accessed date field for each person.
If it helps, the newest Last Accessed date is always the last line of the persons information. So if records 1-6 are George Washington then record six is his most recent, if Ronald Reagan is records 7-9 then record 9 is his most recent, and if Lincoln is records 10-14 then 14 is his most recent.
Any help is greatly appreciated and with my limited knowledge I'll probably need pretty detailed help.
Blessings, Jenna