I have a database with thousands of records. My query pulls records for me based on a date range. Let's say that I have 4000 records that pertain to ONLY 300 patients. How do I get my report to show me in the Report Header the number 300 instead of the total number of records (4000)? The formula I am using is =count([Consumer ID Number]). Normally this would be fine if I wanted to count ALL the records, but I just want to weed out duplicates I guess.