How to create a temperature conversion

[dmartin7]

So I'm using an older Access database(2002) and I'm trying to auto-populate one column to convert Celsius to Fahrenheit. We record all our data in Celsius, but would like to know Fahrenheit as well. I think I have the expression built correctly but not sure if I'm inputting it in the right spot.

So far I have

=([Water_Tempt_C]*9/5)+32

I'm attempting to enter this as the default value or validation rule, but both come up as errors.

Any help would be greatly appreciated.

 

[plog]

No its not the right spot, this shouldn't be in a table. You shouldn't store calculated values, that's what this is. Instead you should use your formula in a query.

Water_Temp_F: ([Water_Tempt_C]*9/5)+32

 

[dmartin7]

No its not the right spot, this shouldn't be in a table. You shouldn't store calculated values, that's what this is. Instead you should use your formula in a query.

Water_Temp_F: ([Water_Tempt_C]*9/5)+32

Ok I created the query, but where would I apply the formula?

 

[GinaWhipp]

In the Field section of the Query, just copy/paste the Formula.

 

[dmartin7]

Ok thanks so much! I actually have another question that is unrelated, but still in the same table.

How do I autopopulate an ID taking information from 2-3 columns?

Example: Trap ID, Date, Week

 

[plog]

You would conatenate them together in a query:

http://www.techonthenet.com/access/functions/string/concat.php

 

[Anakardian]

Whether you stor them or calculate them every time really depends on what you are using them for.
I know you can calculate them but overall it may be simpler to look it up rather than calculate it every time.

Recently I have taken an interest in the BI side of databases and there you never calculate anything if you can store it in a precalculated form.
If you are going to chew through many thousands of records and average up things it is faster to calculate every temperature once and then do whatever you need to do afterwards.