Calculation in Table

[Zandor435]

Is there a way to create a calculation in a table? Nothing complicated, just division/multiplicaiton/addition...stuff like that. I know how to do it in a form, but not in a table. Thanks.

Z

 

[KenReay]

Hi

The answer is that you should do this in a query not a table.
In the query, you make a 'calculated column' so MyCalcColumn: MyColumn1 * MyColumn2

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK

 

[Zandor435]

I see, thanks so much.

 

[Zandor435]

So if I create a form, how do I get the information I calcluated from the query to the form?

Z

 

[KenReay]

Hi

You base the form on the query, ie the query is the recordsource of the form, then the calcualted column is available just like a 'real' column Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK