Is this a imple Query?

[Peer Jones]

Well, take this as a small example:

The table would contain data like this:

Street-----------House-No.------Occupied

Street A-------------1-------------Y
Street A-------------2-------------Y
Street A-------------3-------------Y
Street A-------------4-------------Y
Street B-------------2-------------Y
Street B-------------4-------------N
Street B-------------5-------------Y
Street C-------------3-------------N
Street C-------------5-------------N

(excuse the dashes, they're only for seperation purposes for this page)

and the result should contain information like:

Street A Occupied
Street B PartiallY occupied
Street C Unoccupied