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
(On an infant's shirt): Already smarter than Bush