Results 1 to 2 of 2

Thread: Need Help

  1. #1
    New Lounger
    Join Date
    Jul 2006
    Posts
    19
    Thanks
    0
    Thanked 0 Times in 0 Posts
    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.

  2. #2
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,624
    Thanks
    3
    Thanked 60 Times in 60 Posts
    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.
    Wendell

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •