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.
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.
Comment