criteria filter by an extra field

[Transitioned]

Hi All

Access newbie - normally do my data work in excel. One of the DBAs gave me this query but he isn't available this week:

SELECT GroupHometoUnisys_Min.F2, Min(GroupHometoUnisys_Min.[Min Of DISTANCE]) AS [MinOfMin Of DISTANCE]
FROM GroupHometoUnisys_Min
GROUP BY GroupHometoUnisys_Min.F2;

Its trying to report on the minimum distances between service sites and the service points so we can cost vendors.

F2 has the site name e.g. GH-Alma St
MinOfMin Of DISTANCE is a typo - this field pulls out all the records that have the minum distance (because there are duplicate records)

What I want to do is just add the field "Service_Po" so that the report has the vendor service points as well. But when I do I get all the duplicate records coming back.

So it's knocking out the filtering that the min distance criteria did. Any ideas how to keep that but add this field? I've tried a 'where' but I didn't know the syntax.

[jimatqsi]

Change

GROUP BY GroupHometoUnisys_Min.F2

to

GROUP BY GroupHometoUnisys_Min.F2, Min(GroupHometoUnisys_Min.[Min Of DISTANCE])

Jim