Deleting specific records in table

[BlueCarpet]

Hi, I am new to Access and I was wondering whether it is possbile to carry out the following operation in Access.

I have a Table that contains several hunder records and is updated every day by file transfer. Now this table mayh contain several records for the same unique ID, so for example, ID no 1 could occur 7 times as seven different records. The way the table is set up, only the topmost of these records is of any use to me, the remaining 6 that come after that can be discarded. That way, I am left with only 1 record per Unique ID that I can then use in a Query on another existing table. The question is, is it possible to get Access to delete 6 records and just leave the topmost one intact?

 

[BlueCarpet]

I think the way I phrased the problem is confusing.

Let me try again. Suppose I have someone who writes an exam 10 times in one day. However, it is only the last result of that day I am interested in, not the preceding nine. When the information is entered into a spreadsheet, it will have the StudentID appearing 10 times, with the exam date with a result alongside each record. So I meant unique to the extent that each student is uniquely identified by their ID. However there could be 1000 students per day, each with differing amounts of times they have sat the exam. So, if I only want the first entry with that particular ID, can I ask Access to get rid of the next 9. Is there some way to "loop" through the data to search for each ID, then discard the rest or perhaps loop through and ask Access or Excel or whatever to take each time it first encounters a UniqueID to dump that record into another Table or spreadsheet.