Selective Mean(s) question ...

[efleming]

Is it possible to create a query or report, of sorts, which will yield somewhat more compiled results? I have a query established, based on



tabled forest seed-parasite data, which gives the mean incidence of seed-paratisism per stand in a given operation. I would like, however, to

compile these means so that, instead of a mean for every stand tested in every operation, I have cumulative means per stand and per

operation (I believe this is leaning towards many-to-many relationships, although I am unfamiliar with them?). Is this possible to do from

my broader query? The prospect of creating a new query specific to every single stand and/or operation is a painful one ...



As is, my tables are;


HostSpecies
Key_Species
Species (Name)
Comments

Operations
Key_Operation
Species
Comments

SERFOB_Seeds
Key_SERFOB_Seeds
Key_Operation
Key_Stands
Key_Species
Tree
Cone
GR_GT_collees
GR_GT_abimees
GR_PT
GR_SAINES
GR_VIDES
GR_PARASITEES
Comments

Stands
Key_Stands
Name
Region
Code_SERFOB
Key_Species
Longitude
Latitude
Comments



...sorry for some of the field-names being in French; my present query structure:


Shown: Name (Stands) - Longitude (Stands) - Latitude (Stands) - Operation (Operations) - Species (HostSpecies)

Not shown: GR_PARASITEES (SERFOB_Seeds) - GR_GT_collees ("") - GR_GT_abimees ("")

Mean(s): ([GR_PARASITEES]/[GR_GT_collees]+[GR_GT_abimees])

[June7]

Try using Access report designer Grouping & Sorting features with summary calcs in group/page/report footers.

[efleming]

I began to figure yesterday that it was more a report than a query issue; however, when I try to create the report (name, grouped by operation, means averaged), I get that "unable to preview report, possible because source table is open in exclusive mode" error. When I then-try to preview from design-view, or even to reopen the table, I get the overflow error.

[June7]

Sorry, not familiar with that error, never encountered it. If you can make your project available, will take a look at.