I've been using filemaker for basic scientific datalogging purposes for a little while now and need some help with the logic of generating a report.

I'll simplify the problem to just one table with two fields:

Genus & Location

Here is an example chunk of the data contained in this table:

Genus;Location

Porites;reef1

Porites;reef1

Porites;reef2

Porites;reef2

Acropora;reef1

Acropora;reef1

Acropora;reef1

Acropora;reef2

Acropora;reef3

I need to generate a report that summarizes by location, the number of samples for each genus found at that location.

So for example, the report that I would like to see would look something like this:

Can anybody help me out? I'm sure it's not too difficult, but i'm still trying to get into the filemaker "mentality"

thanks for your help

Edited January 3, 200719 yr by Guest

Crosstab reports is the name of the game, the best way to do it, is without doubt this:

http://edoshin.skeletonkey.com/2006/12/crosstab_report.html#more

--sd

Soren,

What a great link! Thanks for passing that on.

Mike

Wow! thank you so much for the link!

That's exactly what I needed!!!