Count Unique URNs

[JoysTick]

I'm trying to count the number of Unique ClientURNs of Male or Females answering Yes to each question returned by this query.

SELECT DISTINCTROW qry1MajorFilterClients.ClientURN, qry1MajorFilterClients.Gender, [1 Client Visits].[Housing-SeekingHousing], [1 Client Visits].[Housing-Repair], [1 Client Visits].[Housing-Landlord], [1 Client Visits].[Housing-Neighbour], [1 Client Visits].[Housing-Other]
FROM [1 Client Visits] INNER JOIN qry1MajorFilterClients ON [1 Client Visits].ClientURN = qry1MajorFilterClients.ClientURN
GROUP BY qry1MajorFilterClients.ClientURN, qry1MajorFilterClients.Gender, [1 Client Visits].[Housing-SeekingHousing], [1 Client Visits].[Housing-Repair], [1 Client Visits].[Housing-Landlord], [1 Client Visits].[Housing-Neighbour], [1 Client Visits].[Housing-Other]
HAVING ((([1 Client Visits].[Housing-SeekingHousing])=-1)) OR ((([1 Client Visits].[Housing-Repair])=-1)) OR ((([1 Client Visits].[Housing-Landlord])=-1)) OR ((([1 Client Visits].[Housing-Neighbour])=-1)) OR ((([1 Client Visits].[Housing-Other])=-1));

I'm wanting to reference the answer to a report, using for example, for just one of the questions,:
=DCount("[qryZHousing-SeekingHousing]![ClientURN]","[qryZHousing-SeekingHousing]","([Housing-SeekingHousing] = - 1) AND (Gender=2)")
Each question total on the report would have a similar source.

Am I on the right track, or should I take up another interest...

 

[JoysTick]

Pat,

Thanks for the reply, I'd reluctantly come to that conclusion myself, :-(

What field/table structure would be better to normalize this situation?

Thanks
JS