autocalc col in datasheet view

[Jim~C]

Hi,

I'd like to automatically calculate the value of a column based on a numeric
entry in another column from the datasheet view (i.e. I don't want to have
to create a form).

For example, let's say the user is in datasheet view and enters a
temperature value in a column that is based on Fahrenheit. I'd like another
column to automatically be populated with the temperature value converted to
Kelvin. This should also work for any updates made to the value.

Is this possible to accomplish in datasheet view or do I have to create a
form?

I've also considered doing this via a view, but it seems like a waste of
resources since the value never changes once it's converted.

Thanks in advance for any help,
Jim

 

[Guest]

You might just be able to do this in the query. Make an
expression in a blank column of ther query and set it to =
(5/9 *[fahrenheit]) - 305.15. Or make it a text feild in
the form with its control source set to the same
expression.

I think you might need to nz (see help if you are
unfamiliar with nz) the function also to keep from getting
errors when there is no data in the fahrenheit feild. I
hope this helps.