#Error when doing a report calculation

[Guest]

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.

 

[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

 

[Guest]

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

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)

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.