loop individual records for comparison

[wellgoodgod]

While I do have some coding experience, I am a total newb when it comes to VBA. I have a table that has street names, address ranges, and city names. It has been pre-sorted sequentially by address, then city, and looks like this:

address low range high range city
main st 1 2 anytownFl
main st 3 4 anytownFL
main st 10 20 anytownIL

What I need to do is combine the records so there is only one entry per address, per city, like:

address low range high range city
main st 1 4 anytownFL
main st 10 20 anytownIL

I am sure I need to loop through the individual records to make the comparison, but I am unsure how. Any help would be appreciated.

 

[PHV]

You may use an aggregate query (SQL code]:
SELECT address, Min([low range]) AS MinRange, Max([high range]) AS MaxRange, city
FROM yourTable
GROUP BY address, city

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[wellgoodgod]

Thanks for the quick response. Exactly the outcome I needed.