Sum() issue

[JimS]

I have a text box in the header of a continuous form with the following
control source:

=Sum(Round(nz([BoMItemQty]*[tbHourlyRate]*[BoMItemUnitLaborHrs],0),2))

....BoMItemQty is a column in the form's record source
....BoMItemUnitLaborHrs is a column in the form's record source
....tbHourlyRate is a text box in the header of the form

I get a #Error

Ideas?

 

[Dirk Goldgar]

I have a text box in the header of a continuous form with the following
control source:

=Sum(Round(nz([BoMItemQty]*[tbHourlyRate]*[BoMItemUnitLaborHrs],0),2))

...BoMItemQty is a column in the form's record source
...BoMItemUnitLaborHrs is a column in the form's record source
...tbHourlyRate is a text box in the header of the form

I get a #Error

Ideas?

A Sum() expression can use only fields in the form's recordsource, not
controls on the form.

 

[JimS]

Hardly seems fair. Well, due to the properties of multiplication, I can just
move the text box multiplication out to the target text box. That worked.

I suppose I could have used a DSum() instead despite its high overhead.
--
Jim

I have a text box in the header of a continuous form with the following
control source:

=Sum(Round(nz([BoMItemQty]*[tbHourlyRate]*[BoMItemUnitLaborHrs],0),2))

...BoMItemQty is a column in the form's record source
...BoMItemUnitLaborHrs is a column in the form's record source
...tbHourlyRate is a text box in the header of the form

I get a #Error

Ideas?

A Sum() expression can use only fields in the form's recordsource, not
controls on the form.

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)