I am designing an Access report. The control source for my report is a query with four columns of data. Two columns PRECNAME and PRECCODE may have duplicate records, all of which I need to appear on my report are doing so just fine. I have created an invisible text box with a control source =1 in the details section and another visible text box in my group footer section with the control source of that text box. However I only would like a count of the total number of DISTINCT records in each group. How can I accomplish this?