var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: finding the sum and average
today's problem is this:
i have a table that stores numeric values and corresponding dates.
all i want to do is find the sum and average of the values within a specific month.
there's probably a simple VB function to handle this, isn't there.
Why not build a group by query and with the date add a question in the criteria for the invoice like:
GROUP BY is not required if the aggregates are taken over the entire result set, as filtered by the WHERE clause
select [enter month number] as themonth
, sum(thenumber) as sumnumbers
, avg(thenumber) as avgnumbers
= [enter month number]