Alpha Video Training
Results 1 to 7 of 7

Thread: Count of records processed during current session

  1. #1
    Annita Merriweather
    Guest

    Default Count of records processed during current session

    How do I show the number of records processed during the current session? I want to see the count on a form as each new record is entered. When A5 is exited, the count should return to zero. Thank you. Annita

  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 processed during current sess

    Form based on table or set? Count of parent records only or parent and child records?

  3. #3
    "Certified" Alphaholic
    Real Name
    Tom Cone Jr
    Join Date
    Apr 2000
    Location
    Florida
    Posts
    23,312

    Default RE: Count of records processed during current sess

    Count of new records only? New records and changed records? Separate changes to same record count each time?

    -- tom

  4. #4
    Annita Merriweather
    Guest

    Default RE: Count of records processed during current sess

    I want to count the parent records, only new records based on the form. Thanks guys.
    Annita

  5. #5
    Annita Merriweather
    Guest

    Default RE: Count of records processed during current sess

    Hi Tom,

    I want to count new records only. For instance: How many sales were made today? The records are in a table. Thanks Annita

  6. #6
    "Certified" Alphaholic
    Real Name
    Tom Cone Jr
    Join Date
    Apr 2000
    Location
    Florida
    Posts
    23,312

    Default RE: Count of records processed during current sess

    I've been pondering this.

    There are two ways I see that it could be done. In both cases you need to define the requirements more specifically. There's a difference in a running count in each 'session' and a running count for each 'day'. A day could have multiple sessions.

    In general however, here are the two approaches:

    1) when a session begins initialize a counter variable, then increment each time a new record is begun and then saved. Display the variable on the form. I think this would be easy except for the case where a user begins a new record and then cancels.

    2) establish a common field value in all records that are entered in a single 'session' and use tablecount() to calculate the current count of records that have the same field value. The common field value could be a unique session identifier, or more simply, the same 'enter' date.

    -- tom

  7. #7
    Annita Merriweather
    Guest

    Default RE: Count of records processed during current sess

    Thank you. I reacted a field and made the default value 1. I used a count expression to show the number of records saved on a form. I probablly could have also totaled the field to determine the number of records saved for the session. Annita

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
    By crimmelcp in forum Alpha Five Version 4
    Replies: 7
    Last Post: 04-18-2001, 03:11 AM
  3. sum of current selection of records
    By infomatic in forum Alpha Five Version 4
    Replies: 2
    Last Post: 01-28-2001, 11:00 AM
  4. Total of current records
    By Lloyd Frank in forum Alpha Five Version 4
    Replies: 6
    Last Post: 09-01-2000, 07:04 AM
  5. Count of records.
    By Rodney Efird in forum Alpha Five Version 4
    Replies: 1
    Last Post: 05-17-2000, 07:34 AM

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
  •