I have a table with multiple tests, for moisture, protein, enzyme content, and so forth.
Sample Moisture Protein 1 10% 6.0 2 12% 5.5 3 11% 6.3
I need to make a display of statistical information for each test type across all samples.
Moisture Protein Max 13% 7.0 Min 5% 3.0 St Dev 2.5 1.0
I don't know how to do this in Access! Totals kind of works, but it only makes one row, and Totals only appears at the end of an entire query, while I only want one nice little box to put in a report. This is easy in Excel, but Access is needed for other reasons.
Do I need to do this in a form with each cell as a calculated value?