Get stats from related databases

[Tearose]

Soon we will need to start reporting on how many people we had contact with each year by zip code. The information is in 2 related databases. Each new person has a file in the first database that includes the zip code. Each contact with the person is recorded in the related database by date. The databases are related using a file index number. So what I want to do is make a report where I put in the date range (10-01-2006...9-30-2007) and get a list with 2 colums. The list of zip codes in the first column, and how many people contacted that year in each zip code in the second column. Can I do this, and how? If this helps- the databases are in File Maker Server 5.
TIA

 

[JeanW]

My wheels are spinning...

>>The information is in 2 related databases.
No problem.

>>Each new person has a file in the first database...
A file ? Can it be a record ?

>>the databases are in File Maker Server 5
You lost me here.

Basically you want per zipcode how many people and the whole list limited for a date range.

I would suggest to extend your report to a whole year, into 12 parts. Each month a summary.
That will give you the additional flexibility to make totals and averages as well.

You only have to work with summary and sum calculations that will end up in a 12 repetition repeating field.
Your report can be at any breakfield you want.

What I don't know anymore is if the equivalent of Get(Summary) is in FM 5, should you work with FM 5.

 

[Tearose]

Thanks for the response. I haven't worked on this in awhile, because I realized I can do it by hand counting if I have to and we don't need it for another month. I can do a Find to get a list with addresses and zip codes of each person served during the reporting period. What I'd like is a script or report to tell me how many people on the list are in each zip code. Is that easy, or should I just hand count?

 

[JeanW]

Take a look at the summary fields technique.

Make a choice for the break field and sort by it.

Put your fields in a sub-summary when sorted by .... part.

You can make a report per given month and one per year.

Best way to do it is using the wizard.
At the end of the wizard you can opt for a script.
FM will do the hard work for you....