Adding formula to tabes

[simonWMC]

Hello

May be a bit of a stupid question.....but,

How do I add a formula to a cell in an Access 97 table ?

Cheers

Simon

 

[ZmrAbdulla]

Hi,
What formula you want to put?

It is not good to put calculated data in the table.

Regards

Zameer Abdulla

http://www.geocities.com/zameerabd/

http://www.mtkhoory.com

 

[simonWMC]

Basically i want to create a new value by dividing two values from other cells then multiplying by another. the sort of thing you would usually use excel for

why is it not good ?

 

[TheFitz]

It's not a good idea to use calculations in tables.

I can see where you are coming from, but bear in mind, that a computer is designed to complete calculations and therefore storing a value is not needed.

I'm not sure if I am making sense, so let me show you:

You have a table with personal contacts on it. On this table, there is no need to have both a persons date of birth and their age. The two are related to each other.

If I said that "George" was born on the 01/01/1900, you would automatically know that George was 103. I would not need to tell you that George was 103.

In the same way, you can keep base data on a table, but use a query or VBA (code) to complete the calculatioin when you need it.

Hope this helps.

Fitz

 

[simonWMC]

yes it does - thankyou !

I am using dreamweaver to send data to this database. I suppose i can use dreamwever to quiey it also in order to display the results required.

Anyone any experience of this ?