I'm trying to sum a column of numbers on a report, but I keep getting
#Error.

The field on the report is the product of two other fields on the report,
thus: Hrs*Rate, and has a name of EmpRate.

The sum I'm trying to get is of all the EmpRates on the report, so I use
=Sum([EmpRate]) but that fails.

Where's the (obvious) fault in my logic?

Thanks!

--
Bill

PhotoSourceFolio webmaster
http://www.*-*-*.com/

You can't refer to a control contained in the detail. You can use:

=Sum(Hrs * Rate)

Also, make sure you are not attempting to do this in the page footer.

Duane

| I'm trying to sum a column of numbers on a report, but I keep getting
| #Error.
|
| The field on the report is the product of two other fields on the report,
| thus: Hrs*Rate, and has a name of EmpRate.
|
| The sum I'm trying to get is of all the EmpRates on the report, so I use
| =Sum([EmpRate]) but that fails.
|
| Where's the (obvious) fault in my logic?
|
| Thanks!
|
| --
| Bill

| PhotoSourceFolio webmaster
| http://www.photosourcefolio.com
|
|

Could it be that one or more columns are not numeric?

Maybe you could try adding the calculation to the query:
EmpRate:Hrs*Rate {in the QBE grid}

This sometimes helps

JImBAiley