Access VBA

when joining a string together if the same data is held within different records how can you write code so that only one instance of the record is shown on the form but there is a count of the number of times the record is in the database? i.e. house number 16 has flats but you only want to show the house number once and the number of flats contained within it.