If your query contains any grouping fields it will give multiple rows:
For example, see qryIssuesGrouped in the attached:
Code:
SELECT tblIssues.Priority, Count("ID") AS TotalIssues, CInt(DCount("*","tblIssues","Completed=True And Priority = " & [Priority] & "")) AS CompletedIssues, CInt(DCount("*","tblIssues","Completed=True And Priority = " & [Priority] & ""))/Count("ID") AS [%Complete]FROM tblIssues
GROUP BY tblIssues.Priority;
If its not that, please post the query in SQL view or a screenshot in design view