group by and count

[jhollingsworth]

Hello

i really need some help, the step by step kind.

i have a table with a bunch of fields the two I care about are site_id and a plot.  I want to know the number of records in the table for each combination of site_ id and plot.  

I have tried executeSQL but it crashes the table has to many records.

if one of you kind experts could please send me an example of what fields I need to add and the summary/calculations in need to set up.

 i will even give you the messy table if it will help.  

 

https://drive.google.com/open?id=1qapEEbztUGaol8opO8iSC51GQkLyIS1L

 

Thanks

[Fitch]

I'd suggest a sub-summary report:

1. Create a summary field that is the count of site_id

2. Create a new layout -- if you select Report, it will walk you through creating the sub-summary parts, or in Layout mode you can go to Layouts > Part Setup to add sub-summary parts

3. Create a sub-summary part sorted by site_id and another sorted by plot

4. Put your summary field on each of the parts

5. Sort by site_id and plot

That's it.

Welcome to the forums!

[Lee Smith]

Hi jhollingsworth and welcome to the FM Forums,

Your link failed.

Please post your file directly in the FM Forums.

To attach a file, just drag it into the area where you see the paperclip, or use the "choose files..." upload link.