I am having problems writing a query and need help. Table name is maindb, I have a field named hh_num that is assigned a unique number if the address field is unique. So if there are two records with the same address, they will both have the same hh_num. I need to get a total number of records that are Individuals (unique hh_num) and a total of Households (count of hh_nums with multiple matches)
Any help is appreciated.
RG
Any help is appreciated.
RG