updating tabel with automation

[Ravi Kumar]

dear all,

i have a table with 2 columns , 1st is status , 2nd is total qty .
I now want to update the total qty of each status month on month manually.
i there any way to update automatically is either a new table or report.

 

[Ranman256]

Q1: Make a sum query on status.
Q2: Make an update query to update the Qty in the table using Q1

 

[CJ_London]

best practice is to not do this, but calculate in a query as and when required.

however the update can be done if you really need to. you will need an update query and will need to use the dsum function to calculate quantity.

with regards 'automatically', that could mean pretty much anything, but the update could be triggered by a windows timer or an event such as a form open or click of a button