duplicates and gathering info on the web
I have two questions:
1-If I have a large list of names and the list contains duplicates (as many as 8 or ten duplicates for some names) of some of these names, how do I create a list from here without the duplicates? I need the most up to date record of each set of duplicates. I need to find duplicates, identify the latest record out of each set of duplicates, and omit the others, while I combine the latest duplicate record with all of the non duplicated records that I want to pull. In other words, I want to make a list that has no duplicates, and has the most current information.
2-If I want students to be able to access their information on my database and modify it over the internet, can I do that? If so, how?
Thanks; I've been tearing my hair out on this one!