Results 1 to 3 of 3
  1. #1
    Lounger
    Join Date
    Feb 2003
    Location
    Clear Spring, Maryland, USA
    Posts
    32
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Count Records (XP)

    I am trying to put a count field in my report footer that will simply count the records on the report, but when I create a text box with a control source of count it doesn't give me the correct record count. Any suggestions. Also, I can not find the "Search" option on my Woody's Lounge Menu bar. Otherwise, I would have just done a search for this answer. How can I get it back?

  2. #2
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,624
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: Count Records (XP)

    You can't use Count unless you specify a field to count - in general we use the primary key of the control source and count it.

    As to the Search function, it has been disabled for several months because of performance problems - see the [b[Words From On High[/b] for more details. At this point we don't know when we will get it back.
    Wendell

  3. #3
    2 Star Lounger
    Join Date
    Apr 2003
    Posts
    139
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Count Records (XP)

    Hi Pastor Doug,

    What I normally do to get a count is create a query that will count my records and then refer to them in a text box of my report.

    The search feature has been disabled here because of the load on the server [img]/forums/images/smilies/sad.gif[/img] I can't wait to get it back!

    Hope that helps,
    Kindra

Posting Permissions

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