Calculate Totals

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

Guest

Hi Everyone

I'm a very new user to Access and a old user to Excel

I've created a table Called Item Costing

Item_Nu Item_Desc Quantity Cost
Total_Cost

1 Cement 50 R38.89
R1944.50
2 Buidling Sand 9.5 R80.00
R760.00
3 Stable Door 2 R193.00
R386.00

What I'm trying to do is have the Total Cost Field updated automatically.
ie: = Quantity*Cost
& have it total the Total_Cost of all the items at the bottom on the Total
Cost Field.

Your's Truly


Peter Wilson
 
As a rule you should never storew calculations in a table.
It is considered poor design and can lead to probles. Do
the calculations when displaying a form or report.

Chris
 
Hi Everyone

I'm a very new user to Access and a old user to Excel

I've created a table Called Item Costing

Item_Nu Item_Desc Quantity Cost
Total_Cost

1 Cement 50 R38.89
R1944.50
2 Buidling Sand 9.5 R80.00
R760.00
3 Stable Door 2 R193.00
R386.00

What I'm trying to do is have the Total Cost Field updated automatically.
ie: = Quantity*Cost
& have it total the Total_Cost of all the items at the bottom on the Total
Cost Field.

Your's Truly

Peter Wilson
Click to expand...

Stop thinking spreadsheet... think relational database!
There should be no "TotalCost] field.
There is no need to save the total data to any table field.
Any time you need to display the total, calculate it in an unbound
control.
For example, in a Report unbound control in the Detail section.
=[Quantity] * [Cost]
Or to get the grand total in the Report Footer:
=Sum([Quantity] * [Cost)
 
Back
Top