AnsweredAssumed Answered

Creating a summary report

Question asked by k1ngf1sher on Oct 23, 2009
Latest reply on Oct 23, 2009 by philmodjunk

Title

Creating a summary report

Post

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!

 

Thanks,

K

Outcomes