#Error when doing a report calculation

D

Dirk_Bob

I have a table that categorized the hours worked on a job. I builit a
standard query to sort by dates. I built a report showing each person and
the associated hours they spent on the job. In the footer I want to total
the "field billable" hours.
I put in a text box with sum([field billable]). When I view the report, I
get the
#Error in the text box.
 
D

Douglas J. Steele

Is it possible field billable might be Null on one or more records?

See whether sum(Nz([field billable])) makes a difference
 
D

Dirk_Bob

Still getting the same error. I eliminated all but one record in the table.
The
field billable value is 2.

Douglas J. Steele said:
Is it possible field billable might be Null on one or more records?

See whether sum(Nz([field billable])) makes a difference

--
Doug Steele, Microsoft Access MVP

(No private e-mails, please)


Dirk_Bob said:
I have a table that categorized the hours worked on a job. I builit a
standard query to sort by dates. I built a report showing each person and
the associated hours they spent on the job. In the footer I want to total
the "field billable" hours.
I put in a text box with sum([field billable]). When I view the report, I
get the
#Error in the text box.
Click to expand...
Click to expand...
 
Top