Force calculations

[Saintsman]

I have a form - projindex (based on tblprojindex) - users select an item from
a library table, the form has a lookup for a value from the library table,
multiplies that by a quantity entered on the form and stores the result as
index in table tblprojindex. Library item is libraryid. Quantity & index is
saved in the projindex table

The library item changes & I need to update the table projindex totindex to
reflect the recent changes. This will happen reasonably often so I need this
to automate as much as possible

I need to look up the new value for the ibrary item in library table,
multiply by the quantity in projindex table & update the index values

What is the best ways forward?

Many thanks - as always from this forum, which is simply brilliant!

 

[Roger Carlson]

There are very few circumstances under which calculations should be saved,
for precisely the reasons you give here. In most cases, the best solution
is simply not to store them. When you need the result of the calculations,
calculate it in a form, query or report.

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L