Create a report that shows an average but user specify months

  • Thread starter Thread starter DMUM via AccessMonster.com
  • Start date Start date
D

DMUM via AccessMonster.com

Hello

I created a report that is uses a query tp calculate the average of an
accounts available balance for a period of months. I just realized that the
users will need to specify what months they want before the report is run,
therefore requiring that the average can change based on the users input - i.
e between 1/1/2005 and 3/1/2005 = divide sum of account balance for acctA by
3..etc

I'm having problems trying to figure out how to tell the query I want it to
divide by 3 or whatever the number is.

HELP!!! Please
 
Hello

I figured it out - duh!, but I still have a slight problem. When I put in
the dates - say "Between 1/1/2005 and 2/28/2005" I should be getting an
average divided by 2 months, but avg(acctBal) is dividing by 1 instead of 2

Example

1/1/2005 = sum(acctbal) = 316
2/1/2005 = sum(acctbal) = 320
avg(acctbal) = 318

I'm getting avg(acctbal) = 316

When I try 3 months
1/1/2005 = sum(acctbal) = 316
2/1/2005 = sum(acctbal) = 320
3/1/2005 = sum(acctbal) = 0

avg(acctbal) = 212

I'm getting avg(acctbal) = 318

I am using Between "1/1/2005 and 3/30/2005" or whatever the last day of the
month is.
 
Back
Top