using 'find' to sift through records

[Lee_]

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

[Ocean West]

Welcome Lee you can do this using a custom function and some global date range fields you can get a count of the values.

http://www.briandunning.com/cf/868

if you post a sample file with data (the fields you are using for the finds) I can whip something together.