Try

select location, part, MAX(editdate) AS max_ed 
         Form inventory
         GROUP BY location, part

>IF I wanted to just get the latest edit dates from a table
>
>i.e.
>
>select location, part, editdate
>Form inventory
>
>How would I just get the records from the most recent editdate?
>