Results 1 to 2 of 2
Thread: ADDING in a TABLE
2001-05-01, 15:34 #1EsteetechGuest
ADDING in a TABLE
Can anyone help?
I have a 4 column table: Stock No., Cost, Repairs, Total Cost. I want "Total Cost" to automatically display "Cost"+"Repairs". It seems so basic but I cant figure it out. Should this done in a Query or report??
2001-05-01, 15:38 #2
- Join Date
- Dec 2000
- Burwash, East Sussex, United Kingdom
- Thanked 187 Times in 173 Posts
Re: ADDING in a TABLE
If your TotalCost is simply Cost + Repairs, then you shouldn't store it in a table at all (you're effectively duplicating information). Whenever you need the Total Cost, you can create it - in a query, on a form, in a report or wherever.
Hope that helps.Regards,
Microsoft MVP - Excel