You need to do what's called a "correlated sub-query". I haven't done one in a few, so If I make a mistake in this example, I'm sorry but it's something like:

Select location, part, editdate from inventory A where editdate = (select
max(editdate) from inventory B where b.part = a.part and b.location = a.location)

Pf

>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?
>
>Thanks
>Jim