Need Help

[mbetts]

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.

[WendellB]

If you just want to count the number of patients and display that, you need a query that selects just the patient information and excludes duplicates. Then you can use the DCOUNT() function to display that info in the report header.