Summation

  • Thread starter Thread starter fm3c
  • Start date Start date
F

fm3c

I would like to do a Summation with lower bound of summation 0, and n is the
upper bound of summation. Could i used it in a queryBuilder?
 
Use the query designer. In a total query, add an appropriate WHERE condition
(get the word WHERE in the GROUP line of the grid). A WHERE condition
eliminates records BEFORE the summation occur. The produced SQL code may
look like:

SELECT SUM(amount)
FROM myTable
WHERE itemNumber BETWEEN 0 AND [n]




as example.



Hoping it may help
Vanderghast, Access MVP
 
Back
Top