calculate absolute mean

  • Thread starter Thread starter jw
  • Start date Start date
J

jw

Hi,

When I want to see the plots and values for "Species 1"
in a query, I type "Species 1" in the criteria field of
the Species field. Is there a way to get all records to
show up, with "null" in fields that may contain other
species, but not "Species One"?

I want to divide a value associated with "Species 1" by a
count of all plots in a given year.

Thanks in advance for considering my question!
 
I'm not sure I fully understand what you're trying to do, but I'll give it a
go...

If you want all rows that have "Species 1" or a null, you can make that the
criterion:
="Species 1" or IsNull

If you want rows that are NOT "Species One" (note the different spelling),
use that in your criterion:

Not "Species One" (or <> "Species One")

Hope that helps.

Jeff Boyce
<Access MVP>
 
Hi,

Thanks for your response! I am still trying to
understand the analysis I am trying to do, so it is hard
to formulate the question properly.

The analysis was explained as "Show me all the plots"
and "Show me all the plots that have "Species 1". That
way if there are 20 plots, but only 3 that contain
Species 1, Access will not give me a relative average by
dividing the sum of the value for three plots by three,
but rather dividing the sum of three plots by 20.

So I need to be able to calculate a count of all the
plots for the particular analysis. It won't always be
twenty, so I can not just use " /20". If you are not
able to understand, I will have to think about how to
explain better.

Thanks for following this with me!
 
Back
Top