Performing math functions on table entries

[Lost in Microbiology]

I am setting up a database for lab entries where there are dilutions factors
applied. Is it possible to set up a functioin on the field so it calculates
the end number for me?

For example, I have a number field that will need to be multiplied by 6. So,
can I set up an input mask for a number field that will multiply my entry by
6 and store that in the table?

Field Name Data Type
CAC Number CFU of yeast grown on Chromagar candida

I want to enter a number in the table and for it to be multiplied by 6.

Thanks.

 

[Daniel]

If you're using a form for data entry (and you should be!) then you can use
afterupdate events to perform such calculations.