• Goldy it wouldnt as you've already done a distinct Select on the Address which is the same, thus by the time you get to the outer query you only have 1 record returned to do the count on.

    If you change the Second instance of the address to house number 14, you will get a count of two for that postal code.

    _________________________________________________________________________
    SSC Guide to Posting and Best Practices