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 GroupHometoUnis ys_Min.F2, Min(GroupHometo Unisys_Min.[Min Of DISTANCE]) AS [MinOfMin Of DISTANCE]
FROM GroupHometoUnis ys_Min
GROUP BY GroupHometoUnis ys_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.
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 GroupHometoUnis ys_Min.F2, Min(GroupHometo Unisys_Min.[Min Of DISTANCE]) AS [MinOfMin Of DISTANCE]
FROM GroupHometoUnis ys_Min
GROUP BY GroupHometoUnis ys_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.
Comment