Hi,

I am just beginning to use Microsoft Access again and have no idea how to perform calculations in a table.
I have a table which shows a number of fields e.g. a client's age, height and weight. I would like to add a field in the table which calculates BMI using the following formula - weight (in Kilogrammes) divided by height (in metres squared)
Please please can someone help!

depends on how you are inputing the data because that is where the calculation will be done.

The data is being copied from a word document into the table.
Later on I will be creating a form to input the data from the word document into the table. but for now i simply need to enter some backdated data into the table (a year's worth of data).
Previously this data was held in an Excel spreadsheet where it was easy enough to enter a formula to calculate BMI. Now I have no idea how to do it.
Any help would be much appreciated.

Now I have no idea how to do it.

Probably because it can't be done. It will need a form to calculate it. Access doesn't much in the way of "on-entry" calculations

Ok, so it can't be don in the table so please can you tell me how I'd do it in a form? Thanks

dim BMI

BMI = Weight/Height

get the weight and height then store BMI in the table.

the question being WHY do you need to store it in the table? It could simply be calculated as the data is displayed.