Results 1 to 4 of 4
  1. #1
    5 Star Lounger
    Join Date
    Jan 2005
    Posts
    614
    Thanks
    0
    Thanked 0 Times in 0 Posts

    DCount for Report Level (Access2003)

    I need to count Names of the Employees and I am using =Count([EmplNames]) placed into group header.
    I figured some names are duplicates I need to display but do not need to count.
    I had tried DistinctCount but it is probably not an Access function. I had searched on Internet but it doesn't seem like there is anything on Report level.
    please, advice.
    Thanks

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 18 Times in 18 Posts

    Re: DCount for Report Level (Access2003)

    Create a query that returns distinct (unique) employee names, e.g.

    SELECT DISTINCT EmployeeName FROM tblEmployees

    Let's say you name it qryDistinct

    You can then use =DCount("*", "qryDistinct") to display the count of distinct employees.

  3. #3
    5 Star Lounger
    Join Date
    Jan 2005
    Posts
    614
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: DCount for Report Level (Access2003)

    I have this Report that should display non distinct names.
    It all goes off a large table already built. I can not have a separate query just for the count.

    Like GroupHeader_Activity
    Name1-----Activity1
    ---------------Activity2
    Name2-----Activity1

    GroupFooter_Activity Total Names 2
    and I get Total Names 3

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 18 Times in 18 Posts

    Re: DCount for Report Level (Access2003)

    Why can't you have a separate query just for the count? <img src=/S/scratch.gif border=0 alt=scratch width=25 height=29>

Posting Permissions

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