calculations in a table ?

[Richard Farrell]

I have a form that gets its data from a table.The table
has cost data in it for example
basic cost, cost per pound, total pounds, and total cost.
The first column is fixed "basic cost" the second column
varies depending on product and the third column total
pounds varies depending of the quantity purchased. the
final column "total cost" would be the
basic cost +(cost per pound)* (total pounds)= total cost
I can do this in Excel in ten seconds however I an having
trouble trying to find where or how I input the calculated
fields/formulas Thank you in advance

[email protected]
[email protected]

 

[Rosco]

Richard,
You can not do the calculations in the table itself. A database table is
just a holder of data.

To do what you want, you need to do the calculations in a query based on
your table.
hope this helps
Rosco.