Please help!! (Access Calculation)

[devonkay27]

Hi

I am currently setting up a data base for my work and was wondering if there is any way to do the following calculation:

I have a database of automatic doors that are contantly being repaired and i want to keep a record of the accumulated costs involved with this.

I have set up a form to update each door and its accociated repair cost, the problem is when i enter the new repair cost access replaces the current cost with the new. What i would like access to do is add the new cost to the current cost so the accumulated cost can be bulit up over time.

I hope this makes sense

Any help would be greatly appreciated

 

[ZmrAbdulla]

I think you have only a table.
You must have at least two tables.
>> tblDoors
--------DoorID(PK)
--------Details
--------More..

>> tblRepairs
--------DoorID(FK)
--------RepairID(PK)
--------RepairCost
--------More..

Connected with tblID

Reasd more about "Database Normalization"



________________________________________________________
Zameer Abdulla
Help to find Missing people
Sharp acids corrode their own containers.