Adding Values for a Report

[jweeda]

Howdy...

Ok...heres from a total n00b!!!

I work for a Rural Electric Company and I need to build a report that adds 12 months of usage for 1 customer and puts it in a column on the report. There are about 150 customers and I want to show only the TOTAL usage next to the account number and not all 12 months.

How would I build this report and what formulat would I use to get the totals to show?

Thanks in advance!

Jim

 

[GumbyD]

Jim -

You need to use a totals query to get your information. Group your records by Customer and then sum the power usage for each month. Make sure you criteria for the time period you want to sum up (Between 1/1/03 and 1/1/04 or whatever) then use the Where selection in the groupBy row.

Hope that makes sense. If not post back and I will provide more details.

GumbyD

 

[jweeda]

How would I do the grouping? Is there quick method to do that?

My customers are listed by account number. Is there a way to sum up the totals by taking all the values for the account numbers? Just wondering because I don't actually have dates listed. I just had billing send me the usage for the last year.

Jim

 

[jweeda]

HAHA OOPS!!!!

I was messing around in the query and found out what you meant by the grouping! All I did was insert the ACCOUNT, the PERIOD (i guess this was the date), and the UNITS and I grouped by the ACCOUNT, set the PERIOD to Last, and did a Sum on the UNITS. It actually did what I wanted it to do!

Thanks for your help! You pointed me in the right direction!

Jim