Computations in ACCESS

[dechval]

I have received an Access data base, containing expressions such as

%RATE%*((SST_8.5/730)+(%FACTOR%/8760))+TD_ZERO/(24*SST_8.5)

Values associated to the acronyms are stored in different fields of the table or in other tables of the data base.

I would like to compute the value of the expressions and replace an existing field of the table with the results.

As the data base contains around 7000 records, evaluation of the expression must be automatic.

I have never used VBA... Could somebody give me some indications on how to do that?

Thank you

 

[RuralGuy]

You may wish to rethink that position. It is rarely a good idea to store the results of calculations in a table. Much better to recalc every time.

 

[pacg]

Hi deck

To automate:
1. Create a recordset with data that you need - create the field to put on it (you have a lot ex for this)
2. Open RS and with a FOR or WHILE (not rs.eof) put your formula
3. Done