Sum Function

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Kimmer1 - 31 Mar 2008 18:52 GMT

My boss created an Access Database to track Cabinets Painted per Day, what
the Daily Goal is and the difference between the two. He has asked me to go
in and give him a total number of cabinets painted to date and the average
amount of cabinets painted in a day. When I go in and try to do
=Sum([Cabinets/Cylinder Cab's Painted]) and =Sum([Daily Goal]) and
=Avg([Cabinets/Cylinder Cab's Painted]) all 3 of them give me an error.

I have not had any problems setting up his other reports just this one. On
the other reports though I was able to put in a header and footer for
employees that allowed me to isolate data by employee and then calculate my
totals, I have tried to do that here but that hasn't worked either.

Any suggestions?

Reply to this Message

Evi - 31 Mar 2008 20:50 GMT

When you say they give you an error, do you mean that they say Error in the
text box, or that they give you the wrong answer?

Are there any records where there is nothing in any of those fields which
you want to sum ie a blank space rather than merely a 0? If yes, then that
is probably where your errors are coming from.
You may need to add functions like eg
CabsPainted:Val(NZ([YourNumberField],0))
in the query on which your report is based and sum those calculated fields
instead of the ones in your table.

Evi

> My boss created an Access Database to track Cabinets Painted per Day, what
> the Daily Goal is and the difference between the two. He has asked me to go
[quoted text clipped - 9 lines]
>
> Any suggestions?

Reply to this Message