Creating a summary report
Hi all, I have what is probably a very simple problem that I cannot figure out. Here's the sceario: I have farmers ('Farmer') who own several fields ('Field_name') and for each field, I collect multiple soil samples ('Bar_code') in different years ('Year'). What I would like to do is create a summary by: Farmer, Field_name, Year, but only lists the minimum and maximum value for the bar_codes. My recent efforts have yielded a summary, but it yields a report that lists every single soil sample and the min & max for that farmer & field. I would really appreciate any help on this!