calculations in a table ?

  • Thread starter Thread starter Richard Farrell
  • Start date Start date
R

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

(e-mail address removed)
(e-mail address removed)
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access 2003 : Saving data entered via a Form 6
Calculate form field using another table, Dim statement 0
VBA Excel - Select a value from one cell in Excel to update a SQL table 1
Sum in Main Form from Subform 7
Populating a field in a table from an unbound field in a form. 5
Calculate report Total where subtotal uses IIf function 2
How do I calculate a sum between a combo box and an input box? 2
Updating Fields in One Table Based on a Field in Another Table 1

Back
Top