the reason i am doing this is that i have a large table that has multiple entries for a "part number" and i just want the last ones. so, i am making this copy of the table, then set the primary key for the "part number" , sort the table descending by date and then copy it is. is there a better way to do this?
lots of other fields. i just want the latest (03-02-2001) in the table. i make the new table with the same structure and the field with 12345 as primary key. then have an append query sort the original table to the new one. since i cant have duplicate primary keys, all but the first are discarded. just wonder if there is a better way of doing this. found the procedure on a microsoft q&a site.