Address combination

[Silverad0]

Hello all I am using MS access for a little personal project and I have house number and streets along with a day they are serviced.
example:

unit road type day
1 main st friday
2 main st friday
3 main st friday
4 main st friday
5 main st friday
6 main st friday
7 main st friday
13 turtle st monday
15 turtle st monday
16 turtle st monday

I want to make a report of this data to look like this

unit road type day

1-7 main st friday
13-16 tutle st monday


anyone handy with access and know how to do this . I am having a hard time wraping my head around the functions of classing the numbers together. I dont know if I need to make a query first or not. I looked at the query options but they seem to be limited in sorting and only give me duplicates. I am missing something and I know it is due to my limited knowledge of access.
thank you for your help guys (and girls)

 

[Sum Guy]

I think your problem may be that you have your grouping wrong.

Your query should be grouped by day, not by number.

 

[Silverad0]

naw what I did was take unit and I put it in 2 times one fo min and one for max and then I grouped the road by ascending and it worked out

 

[CraigDolphin]

So how does your solution work if you spend days 1-2 at some address, then day 3 and 4 at another address, then you go back to the first address for the last day?