summing currency fields on an unbound text box 1

[integritycare]

Hi guys,

Is it possible to sum unbound currency text boxes.

I have to be able to track information from generated invoices per client.
The data available to me from the invoices is the hours supplied by the rate.
So in the detail section on a form it would be;

The control source on an unbound textbox (name is DayHrs)set to currency is

=nz([Dtotal])*nz([BDR])

In the form footer I have an unbound currency textbox with this;

=Sum([Dayhrs])

But this generates an error. Can this be done?

Regards,

Integrity

 

[PHV]

What about this ?
=Sum(Nz([Dtotal],0)*Nz([BDR],0))

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[integritycare]

Hi PHV,
Thanks for that...
It is so great to have guys like you with all this knowledge to help us out.
So greatly appreciated.

Integrity