Alpha Video Training
Results 1 to 2 of 2

Thread: Report Field Value counts

  1. #1
    Member
    Real Name
    Shawn Kendall
    Join Date
    Jul 2003
    Posts
    2

    Default Report Field Value counts

    Hello,

    I am using A4v1.1 and have a database of 1800+ records that has 5 fields with recurring values from 1-39. I would like to count the number of records that have the value 1 within any of those 5 fields and then repeat for each of the 39 possible values. I would then like to show on a report or form of some kind what those counts are. I also have A4v6 that I can use as well, but the database is on an older palmtop (HP 200lx) that does not have the ability to run A4v6, and would prefer to do it all on the palmtop. Example:

    RecNo.......F1.........F2.........F3.........F4.........F5
    1................1..........5.........15.........20.........25
    2................6........12.........15.........22.........27
    3................3..........5.........10.........12.........25
    etc


    Report:

    Val.........F1.........F2.........F3.........F4.........F5
    1.............1...........0...........0...........0...........0
    3.............1...........0...........0...........0...........0
    5.............0...........2...........0...........0...........0
    etc

    The fields are all numeric fields and whether a blank or a zero shows up for counts that are empty doesn't matter. The dots are just spacers for the message board. Anyone have any ideas? Thanks in advance for your suggestions.
    Last edited by shawnmk; 12-10-2005 at 12:40 AM.

  2. #2
    Member
    Real Name
    Gary Smith
    Join Date
    Apr 2000
    Posts
    180

    Default

    I don't have A4V1. If that version permits, you could create a report that contains 195 calc fields (5 * 39) and put them in the summary section. I attached a sample report that I created using A4V8. It only counts values from 1 - 5 instead of 1 - 39, but you'll see the concept.

Similar Threads

  1. Repeating field in report
    By Ronald Anusiewicz in forum Alpha Five Version 5
    Replies: 4
    Last Post: 12-22-2003, 06:30 PM
  2. Field in report
    By Linda D. Cox in forum Alpha Five Version 4
    Replies: 1
    Last Post: 08-23-2002, 02:01 PM
  3. Percent of Counts in Reports
    By Chris.Tanti in forum Alpha Five Version 4
    Replies: 14
    Last Post: 06-15-2000, 12:23 PM
  4. Conditional Counts
    By Jim VanGelder in forum Alpha Five Version 4
    Replies: 2
    Last Post: 05-17-2000, 05:34 AM
  5. Printing group counts in order
    By Pete Cantele in forum Alpha Five Version 4
    Replies: 2
    Last Post: 04-13-2000, 10:00 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
  •