big problems - please help

[Frank Parker]

i have included the statement below - in a nutshell what i
am attempting to add is a total of UNIQUE Codigo's
(customers) to this report for each salesrep.i am trying
to show that over a certain date range that each salesrep
has spoken to this many unique customers (codigo's) -.
Thanks in advance
Frank
SELECT TBLSALESREP.Region, TBLSALESREP.SalesRep, Count
([TBL GENERAL].[RO#]) AS [CountOfRO#],
TBLSALESREP.YearlyGoalPieces, QRYInvoiceAmt.[SumOfREPAIR
PRICE], QRYQNASaleReport.QNA, QRYANFSalesReport.ANF
FROM (QRYANFSalesReport RIGHT JOIN (QRYQNASaleReport RIGHT
JOIN (QRYInvoiceAmt RIGHT JOIN (TBLSALESREP INNER JOIN
CLIENTES ON TBLSALESREP.SalesRep = CLIENTES.VENDEDOR) ON
QRYInvoiceAmt.SalesRep = TBLSALESREP.SalesRep) ON
QRYQNASaleReport.SalesRep = TBLSALESREP.SalesRep) ON
QRYANFSalesReport.SalesRep = TBLSALESREP.SalesRep) INNER
JOIN [TBL GENERAL] ON CLIENTES.CODIGO = [TBL GENERAL].
[CUST ID]
WHERE ((([TBL GENERAL].[RCVD DATE]) Between [Start Date]
And [Ending Date]))
GROUP BY TBLSALESREP.Region, TBLSALESREP.SalesRep,
TBLSALESREP.YearlyGoalPieces, QRYInvoiceAmt.[SumOfREPAIR
PRICE], QRYQNASaleReport.QNA, QRYANFSalesReport.ANF
HAVING (((Count([TBL GENERAL].[RO#])) Is Not Null));