Concatenate 10 street address ranges into specific Fire district

[Guest]

I need to join/concatenate all the street address ranges that are in a specific district
I have 10 segments of Smith Rd that are in District 10 and 25 segments that are in District 9
Each of these records has a
Streetname, Smith R
Low for the left side (1)
High for the left side (9),
Low for the right side (2),
High for the right side (10)
Fire District (1 thru 10

In English: take all 25 of the Smith Rd records that are in Fire district 9 and make one record with the lowest address from the left or right side and the highest address from the left or right side
Instead of 25ea Smith Rd records that all say District 9...have 1 recor

So the end product reads Smith St Low (1) High (302) District (9)
Thank yo

 

[Fons Ponsioen]

From what I read into what you wrote, I think you want to
group the data by district, street, and segment while
printing in the footer the Min and Max of the segment
number for the Left and Right side of the street.
You could set up the report exactly as I described here.
Hope this helps.
Have a great Thanks Giving.
Fons

-----Original Message-----
I need to join/concatenate all the street address ranges

that are in a specific district.

I have 10 segments of Smith Rd that are in District 10

and 25 segments that are in District 9.

Each of these records has a
Streetname, Smith Rd
Low for the left side (1),
High for the left side (9),
Low for the right side (2),
High for the right side (10),
Fire District (1 thru 10)

In English: take all 25 of the Smith Rd records that are

in Fire district 9 and make one record with the lowest
address from the left or right side and the highest
address from the left or right side.

 

[Guest]

Thanks Pons
Not in a footer...but throughout the report. I have 50,000 records. I reworded it alittle.
In English: take all 150 of the Smith Rd records that are in Fire district 9 and make one record with the min address from the left or right side and the max address from the left or right side.

So the end product reads
Smith St min (1) max (302) District (9)
Smith St min (304) max (557) District (10)
Instead of 150ea Smith Rd records that all say District 9...have 1 record. Then repeat for the next pile of Smith Rd segments that are in the District 10. Then repeat for the next street in alphabetical order after Smith.

Thank you


----- Wally wrote: -----

I need to join/concatenate all the street address ranges that are in a specific district.
I have 10 segments of Smith Rd that are in District 10 and 25 segments that are in District 9.
Each of these records has a
Streetname, Smith Rd
Low for the left side (1),
High for the left side (9),
Low for the right side (2),
High for the right side (10),
Fire District (1 thru 10)

In English: take all 25 of the Smith Rd records that are in Fire district 9 and make one record with the lowest address from the left or right side and the highest address from the left or right side.
Instead of 25ea Smith Rd records that all say District 9...have 1 record

So the end product reads Smith St Low (1) High (302) District (9)
Thank you

 

[Fons Ponsioen]

It still would work, Group it by District and Street or
alternatively by street and district, than if you do this
in a summing query you can max and min the numbers
correspondingly.
This will work I think
Have a Happy Thanksgiving.
Fons

-----Original Message-----
Thanks Pons
Not in a footer...but throughout the report. I have

50,000 records. I reworded it alittle.

In English: take all 150 of the Smith Rd records that

are in Fire district 9 and make one record with the min
address from the left or right side and the max address
from the left or right side.

So the end product reads
Smith St min (1) max (302) District (9)
Smith St min (304) max (557) District (10)
Instead of 150ea Smith Rd records that all say District

9...have 1 record. Then repeat for the next pile of Smith
Rd segments that are in the District 10. Then repeat for
the next street in alphabetical order after Smith.

Thank you


----- Wally wrote: -----

I need to join/concatenate all the street address

ranges that are in a specific district.

I have 10 segments of Smith Rd that are in District

10 and 25 segments that are in District 9.

Each of these records has a
Streetname, Smith Rd
Low for the left side (1),
High for the left side (9),
Low for the right side (2),
High for the right side (10),
Fire District (1 thru 10)

In English: take all 25 of the Smith Rd records

that are in Fire district 9 and make one record with the
lowest address from the left or right side and the highest
address from the left or right side.