Alpha Video Training
Results 1 to 2 of 2

Thread: Count of records.

  1. #1
    Member
    Real Name
    Rodney Efird
    Join Date
    Apr 2000
    Posts
    137

    Default Count of records.

    I need to be able to show the total number of records in a table and at the same time show the number of records that satisfy filter settings.

    When a button is pressed to select and show records that satisfy the index for example, I still need to be able to indicate the grand total for all records in the table.

    Thanks

    R Efird

  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: Count of records.

    Where do you want to show these totals?

    If you are using a button to set an index, first set the index to record order number, fetch the last record, capture the recno() to a variable (this is the total), then proceed with your normal process to set your index. Display as desired.

Similar Threads

  1. Count records
    By Amateur in forum Alpha Five Version 5
    Replies: 11
    Last Post: 09-12-2004, 08:44 PM
  2. Count records in report
    By dcorcoran in forum Alpha Five Version 5
    Replies: 3
    Last Post: 02-28-2004, 10:46 PM
  3. Query Records Count
    By David Agan in forum Alpha Five Version 5
    Replies: 2
    Last Post: 10-04-2002, 01:08 PM
  4. count records
    By crimmelcp in forum Alpha Five Version 4
    Replies: 7
    Last Post: 04-18-2001, 03:11 AM
  5. Count records in a query
    By Jamin Dunivan in forum Alpha Five Version 4
    Replies: 5
    Last Post: 04-17-2001, 12:33 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
  •