I am trying to create a query ordered by ...
(table: field, grouping, sorted)
-----------------------------------------
HostSpecies: Key_Species; group-by
Stands: Key_Stands; group-by; ascending
Operation: Key_Operation; group-by
Seeds: GR_Parasitees; sum
-----------------------------------------
My sum, however, keep returning numbers
way in excessive of what the referred-to
data actually sums to. E.G.,
As tested in Excel, Key_Species/Stands/Operation 2/100/4 should yield a [GR_Parasitees] sum of 1118. Instead, however, my query is giving said-data a [GR_Parasitees] sum of 74764. Any suggestions?