Alpha Video Training
Results 1 to 4 of 4

Thread: Record Count on label Field

  1. #1
    Member
    Real Name
    Chris Turnbull
    Join Date
    Oct 2009
    Posts
    445

    Default Record Count on label Field

    Hi All,

    I have a grid that has 5 fields (Columns) the records either contain a Y or are blank. I would like to put a total at the bottom of each Column for the amount of "Y's" in that column. How would I do that please.

    Thanks

    Chris

  2. #2
    Volunteer Moderator
    Real Name
    James A. Talbott, Jr.
    Join Date
    Apr 2000
    Location
    Lexington, KY
    Posts
    1,455

    Default Re: Record Count on label Field

    I would create a calculated field for each of the five fields, and let the value be 1 for each Y, then hide the calculated fields, then total that column . You will have to insert the total through the events, but it is not difficult.
    Let us know if you need more help.
    Jay
    Jay Talbott
    Lexington, KY


  3. #3
    Member
    Real Name
    Chris Turnbull
    Join Date
    Oct 2009
    Posts
    445

    Default Re: Record Count on label Field

    Jay,

    Thanks for the reply - I did think

  4. #4
    Member
    Real Name
    Chris Turnbull
    Join Date
    Oct 2009
    Posts
    445

    Default Re: Record Count on label Field

    I would have to do something like that but didn't know how to go about it so any help would be fantastic.

    Thanks

    Chris

Similar Threads

  1. How do I do a record Count on a Label Field
    By Turnbullca in forum Application Server Version 10 - Web/Browser Applications
    Replies: 0
    Last Post: 10-09-2011, 05:02 PM
  2. Grid with fields from several tables, including a record count field
    By Jose Bonnet in forum Alpha Five Version 8
    Replies: 2
    Last Post: 07-22-2007, 06:37 AM
  3. record counting -- not count last record
    By dik_coleman in forum Alpha Five Version 6
    Replies: 6
    Last Post: 01-17-2006, 01:06 AM
  4. record count - delete button adjusting count
    By dik_coleman in forum Alpha Five Version 7
    Replies: 3
    Last Post: 12-23-2005, 12:06 PM
  5. reseting record count in an autoincrementing field
    By ken in forum Alpha Five Version 6
    Replies: 4
    Last Post: 09-17-2005, 10:35 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
  •