Very Computer

Locality 1
        Family Aidae
                Aus a
                Aus b
                        Total species of Family Aidae at Loc. 1: 2
        Family Bidae
                Bus c
                Bus d
                Bus e  
                        Total species of Family Bidae at Loc. 1: 3

                        Total Species at Locality 1 in all Families: 5
and so on for each locality.

When I have tried to generate this report, either using the report layout
wizard or manually, I get the first Family name and the count field shows the
total number of taxa listed in the Join Table. This happens regardless of what
subsummary the count field is listed in. I have tried creating the count as a
summary field in the join table because I cannot see the fields that need
counting from the Localities table. I have tried setting up the reports in both
the Localities table and in the Join Table, and I get weird results either way.
Please tell me if this is something simple that I am screwing up, and how to
fix it. I have spent hours with the manual, the FMPro 5 Bible, and on the web,
and can't seem to get any answers.
Thanks very much in advance,

Jessica Theodor

This report should work if you run it in the join database ( FMPro doesn't use
tables ).  How are you doing your sort?  I created a roughly similar ten-minute
model and plugged in some records, and in the join database created a report layout
of extended columnar type with the parts:

Header
Sub-summary when sorted by Locale
Sub-summary when sorted by Family
Body
Footer

I put headings in the Header, pretty much just as you have them, and then put the
field "Locale" in the Sub-summary by Locale, the field "Family" in the Sub-summary
by Family ( a bit to the right ), and the field "Species" in the Body ( another bit
to the right ).  I made a summary field = Count of "Species" and put it in the
Sub-summary by Family, which is a little different than your example, but it must
be there to summarize properly.  I gave it a text label "Number of Species in
Family <<Family>> in Locale <<Locale>>" with merge fields as indicated, and placed
the text label in the same part.  Then I put the same summary field in the
Sub-summary by Locale, with the appropriate text label.

When I sort by Locale, then Family, and go to Preview my report looks pretty much
like you want.  I hope this is helpful, please give it a try and let me know if you
still have problems.

Best of Luck -
James