Alpha Video Training
Results 1 to 4 of 4

Thread: Record count in filtered form

  1. #1
    "Certified" Alphaholic
    Real Name
    Charlie Crimmel
    Join Date
    Apr 2000
    Location
    West Virginia
    Posts
    1,695

    Default Record count in filtered form

    To all:
    I need to do a count of records on a filtered form.
    I am using recno and reccount

    It seems like it is doing the record count on the entire table and not just the filterd records on the form.

    Is there a way to count the records showing on the filtered form.

    Example:
    I want to see all the records where a sold flag is set to true.
    I set the filter on the form, but the reccount is still showing all records
    var-"reccount=reccount

    Charlie Crimmel

  2. #2
    "Certified" Alphaholic Stan Mathews's Avatar
    Real Name
    Stan Mathews
    Join Date
    Apr 2000
    Location
    Bowling Green, KY
    Posts
    25,119

    Default RE: Record count in filtered form

    Hey Charlie,

    Is the form filtered by query or be form definition?

    If you are querying you can use "INDEX".RECORDS_GET() or if you have the filter in the form's definition I think you'll have to use tablesum() or dbsum().

  3. #3
    "Certified" Alphaholic
    Real Name
    Charlie Crimmel
    Join Date
    Apr 2000
    Location
    West Virginia
    Posts
    1,695

    Default RE: Record count in filtered form

    The for has a filter in the form definition

    Charlie Crimmel

  4. #4
    Member
    Real Name
    Steve Andrews
    Join Date
    Jan 2004
    Location
    Mahwah, NJ
    Posts
    644

    Default RE: Record count in filtered form

    Charlie,

    Take a look at A5_Get_Records_In_Query().

Similar Threads

  1. Index on form record count
    By chadg@epix.net in forum Alpha Five Version 5
    Replies: 3
    Last Post: 01-04-2005, 05:10 PM
  2. Count Records in a filtered Data Bank
    By Cyrus in forum Alpha Five Version 5
    Replies: 8
    Last Post: 11-22-2004, 02:58 PM
  3. Getting a record count
    By Steve Sawyer in forum Alpha Five Version 5
    Replies: 7
    Last Post: 07-23-2003, 12:08 AM
  4. First Record with a Filtered Form
    By Alan Lucas in forum Alpha Five Version 5
    Replies: 5
    Last Post: 06-03-2003, 06:37 AM
  5. Form Load Query Record Count
    By Peter.Greulich in forum Alpha Five Version 4
    Replies: 5
    Last Post: 09-03-2001, 02:37 PM

Bookmarks

Posting Permissions

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