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

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!

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.