updating a calculation form

[kabir_hussein]

Hi i am doing a database for a order system and would like to ask if someone knows how to update an order system automatically.

I am making a ordering system where the user will order a 100 items and then in the space on three months they will recieve 30 items one month, 40 items the next month and so on. i was wondering does any one have any ideas how i could make a order table where i could simple type in one table the amount delivered each month and a total column will simple calculate the total delivered each time

many thanks in advance

kabir hussein

 

[namliam]

Dont store calculated values... If you are storing the delivered items, there is no need to store and recalc the total every time. Just calc it "real-time" using a sum ...

Regards

 

[kabir_hussein]

do u mean like in a report or something as i have done that but wanted to know if there was a nother way in which i could make life easier for users

 

[namliam]

As a rule of thumb: Dont store calculated values but calculate them when and where you need them in a query on a form or report...

Regards