[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: Developing an MS Access Activity Calculator



Dave,



There are a couple of different options for performing calculations in Access.



You'll want to create a calculated field in your query used to generate your 

report.  The output will not be saved in a table.



You can also create calculated fields on a form.  These results are not saved 

to a table, but you can print the current record on the form for a hard copy 

output.  Each time you open the form, you'll see a decay-corrected value.



Tables do not store formulas and will not automatically store the output of a 

calculation.  Use an "update" query to store the calculated value back in the 

table.  You can update the entire table or just one record.



To perform a hard write back to the table for a single record on a form, 

create a button attached to the update query that has all of the fields on the 

form and the field you wish to hard write back to the table.  Another good use of 

this is for generating tracking numbers which may be a concatenation of parts 

of several fields to create a unique tracking number.



Have fun,



Glen Vickers