Results 1 to 3 of 3
  1. #1
    Bronze Lounger
    Join Date
    Feb 2001
    Location
    Escondido, California, USA
    Posts
    1,458
    Thanks
    0
    Thanked 1 Time in 1 Post

    Count Error (2003)

    i have a text box with =count(*) entered in the footer of a report, but the report always returns "Error". Any idea why the count function doesn't work?

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

    Re: Count Error (2003)

    In which footer have you placed the text box? It should work in the report footer, but not in the page footer. If you want a record count in the page footer, proceed as follows:

    - Create a text box in the Report Footer with control source =Count(*)
    - Set its name to txtCount and its Visible property to No.
    - Create a text box in the Page Footer with control source =[txtCount]

  3. #3
    Bronze Lounger
    Join Date
    Feb 2001
    Location
    Escondido, California, USA
    Posts
    1,458
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Count Error (2003)

    Thank Hans, that was it. I hadn't noticed that I had Page Footer enabled instead of Report footer.

Posting Permissions

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