S
Steely via AccessMonster.com
I am currently attempting to create an expression that will sum a
particular field for several records in a table based upon a unique id
number. For example, I have one table with a variety of stream data and
each site has a unique id number. These sites have been sampled between
one and four times and I would like to have an expression sum several of
the parameters collected or measured at these sites( e.g. number of wood
pieces). Does anyone have advice on how to go about creating this type of
expression? Basically, I would like to write code that says when records
in the table have the same Site ID, sum the number of wood pieces for that
site so I can get a grand total for all site visits. I would then
eventually like to get a max value based upon these sums for all site
visits. Also, how would I do this for parameters that may contain null
values?
Any help would be appreciated.
particular field for several records in a table based upon a unique id
number. For example, I have one table with a variety of stream data and
each site has a unique id number. These sites have been sampled between
one and four times and I would like to have an expression sum several of
the parameters collected or measured at these sites( e.g. number of wood
pieces). Does anyone have advice on how to go about creating this type of
expression? Basically, I would like to write code that says when records
in the table have the same Site ID, sum the number of wood pieces for that
site so I can get a grand total for all site visits. I would then
eventually like to get a max value based upon these sums for all site
visits. Also, how would I do this for parameters that may contain null
values?
Any help would be appreciated.