Link to home
Start Free TrialLog in
Avatar of tpigielski
tpigielski

asked on

Calculated field on Access Form

I need to calculate a value in a field in the footer section of a form (e.g. Sum), but need to multiple that value by a number that is in another footer field.  Access keeps giving me an error when I reference the other footer field.  (I'm actually trying to multiply the sum of one of the detailed columns by a percentage that is stored in another footer field).

Thanks...Tom
Avatar of DatabaseMX (Joe Anderson - Former Microsoft Access MVP)
DatabaseMX (Joe Anderson - Former Microsoft Access MVP)
Flag of United States of America image

Show the calculation that is giving the error ...

mx
What is the specific error?

Here's a good primer on how to reference conmtrols between forms/subform.
http://www.mvps.org/access/forms/frm0031.htm

Scot
Avatar of tpigielski
tpigielski

ASKER

This is the calc giving the error:

=Sum(([Quantity On Hand]*[UnitPrice])*(1-[txtDiscount]))

Quantity On Hand and UnitPrice are in the Detail section of the form.  txtDiscount is in the footer section of the form.
Thanks..Tom
What is the error?

Error number?
no error number...just #ERROR in the field when I get out of design view.
In that case it's not understanding something in your formula..

Can you post a screenshot of the form with the error displayed?
ASKER CERTIFIED SOLUTION
Avatar of Dale Fye
Dale Fye
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
As fyed is implying, you cannot user Sum (or other aggregate functions) on Controls, only on bound fields in your form/report.

mx