Calculating Product in a continuous form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi all,

I'm trying to calculate Product in a continuous form, and I have no idea how
to do it.

The textbox that is doing the calculation is in the footer. In Excel, to
multiple multiple cells together you say PRODUCT(A1:A5), but I can't find an
equivalent in Access. If anyone can help me out with this, I'd appreciate
it. I'm at a complete loss.

Thanks,
Jay
 
Because of bad spelling, I might not have been clear.

I want all instances of a certain field in a continuous form multiplied
together and displayed in the form footer.

Hope that clears it up.

Thanks,
Jay
 
Jay said:
I'm trying to calculate Product in a continuous form, and I have no idea how
to do it.

The textbox that is doing the calculation is in the footer. In Excel, to
multiple multiple cells together you say PRODUCT(A1:A5), but I can't find an
equivalent in Access. If anyone can help me out with this, I'd appreciate
it.
Click to expand...


Right, Access does not have that function. However you can
use the mathematical eguivalent:

=Exp(Sum(Log(thefield)))
 
Back
Top