Results 1 to 3 of 3
  1. #1
    Silver Lounger
    Join Date
    Jan 2002
    Posts
    1,615
    Thanks
    0
    Thanked 1 Time in 1 Post

    Incorrect count returned in report (2002)

    Hi,

    I have a report that contains a control that should return the count of the number of records in the query. The query shows a total of 12 records but the control answer shows 2. I'm using =Count(*) as the formula. I've already checked to be sure the control was big enough to hold the full number and it is so that wasn't the problem. Is the formula I'm using correct? I simply need the count of the total number of records in the report.

    Thanks,
    Leesha

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

    Re: Incorrect count returned in report (2002)

    Did you put the text box in the report footer section? If you put it somewhere else, your results may vary.

  3. #3
    Silver Lounger
    Join Date
    Jan 2002
    Posts
    1,615
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Incorrect count returned in report (2002)

    Thanks Hans! That was it. I had it in the employee header. Put it in the report header and the numbers are now correct.

    Leesha

Posting Permissions

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