Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2005
    Posts
    45

    Unanswered: Report Count Help!

    I have database where it holds info about employees. In report, I want to show total number of current employee. I inserted a text box and put
    Control Source = [count]
    but I get the wrong count on each report page. Please Help!


    ex
    employee
    a
    b
    c
    d

    total: 9

  2. #2
    Join Date
    Mar 2003
    Location
    The Bottom of The Barrel
    Posts
    6,102
    Provided Answers: 1
    Where do you want the count to appear and what value are you shooting for? If you want the total number of employees in the entire table, put something like "=COUNT([yourField])" in the report footer.
    oh yeah... documentation... I have heard of that.

    *** What Do You Want In The MS Access Forum? ***

  3. #3
    Join Date
    Jun 2005
    Posts
    45
    Thanks Buddy, Worked like a charm.

Posting Permissions

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