Hi,

I've got 150.000 datasets in a Filemaker file. A "date" field within
each data set shows the date (between 01.01.1996 and current day) on
which the set has been added.

How can I generate a list that shows every month with the whole amount
of datasets created in it? Something like...

01.1996 255
02.1996 461
03.1996 323
....

Thanks for your help!

Martin

On 8/6/03 4:47 AM, in article
7168c377.0308060347.1a551e0d (AT) po...OT) google.com, "Martin Skultety"
<martinskultety (AT) hotmail (DOT) com> wrote:


First you need to know which month each dataset is in.
Create a calculation field that gets the month and year of each dataset.
dataMonth = (Year(date) * 12) + Month(date)
This gives each month of the calendar a unique number.

Then you need to count the records in a dataset.
Create a summary field that counts records for the field dataMonth.
monthCount = Count(dataMonth)

Now you can generate a report.
Create a layout with header, footer and sub-summary parts. No body.
Make the sub-summary sort field point to dataMonth.
Place the date and monthCount fields in the sub-summary part.

To generate the report you need to sort first.
Sort by dataMonth, so that the report summarizes when dataMonth changes.

You may want to format the date field to reflect your month.year format.

That's it.


Matt Revenaugh