To ascertain 8 different numerical results for a report is there an easier way than I'm currently using.
The exercise is to count the number of records after each 'find' has been completed. For example I need to find the number of records that fall between a specified date period (easy of course), so an initial find is completed for records within that specified period, say 117 are found. Within those records there are 8 different criteria, some within the same fields and others in different fields.
First I need to find the number of records that may have a 'P' in a field, then the number of records that may have a 'F' in that same field. Next, I need to find the number of records that have a'C' in another field. All these 'counts' are from records that fall within the same date range.
At the moment I have a script that creates the same initial find (by date period)then counts the 'P' records and pastes that result to a global field (global_1), then the script repeats the same find and counts the number of 'F''s and pastes that the (global_2) and so on. Eventually it displays a layout showing all the global fields alongside the appropriate notation for each count.
I was wondering if there was a cleaner way by completing an initial date period 'find' then through a looping action filemaker counting the appropiate number for each required record count
