Form Calculations

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

Guest

How do I make a calculation on two form entries and have that calculation update to the main table

Expample: Sales Entry Cost Entry Gross Profit ( Sales - Cost

Thank You
 
Sadly you can't, if you want a total calculated on the
form you cannot have it on the table, however you may be
able to set it to also calculate it on the table. I had
this problem and deleted the field on the table and just
entered the calculation on the form
-----Original Message-----
How do I make a calculation on two form entries and have
Click to expand...
that calculation update to the main table.
 
Flic said:
Sadly you can't, if you want a total calculated on the
form you cannot have it on the table, however you may be
able to set it to also calculate it on the table. I had
this problem and deleted the field on the table and just
entered the calculation on the form
Click to expand...

You should ask *why* instead of *how*. What value is a stored
calculation if one of its components changes?
 
Back
Top