calculating fields

[sander]

hi there,

i am having trouble with a acces database.....

here is what i want:

i have a asp page which updates 2 fields in the table
clients named height and width there is a third field
named sum...... as you probably guessed by now i want
the sum field to automaticly get filled in by height
multiplied by the width every time a record is added...

how do i do this do i need an extra excel formula or
something.......

remember it is for a website thus must be usable on a
webserver w2000 asp....

thanks in advance and sorry for the bad english...

greetings Sander Kerstens from Holland

 

[Tim Ferguson]

as you probably guessed by now i want
the sum field to automaticly get filled in by height
multiplied by the width every time a record is added...

No you don't. You want to display it -- either on a form or a report or a
web page or whatever.

Base the thing on a query that contains the calculated field, and it will
always be correct regardless of edits and updates to the source field.

Welcome to the wonderful world of databases, which is entirely different
from the wonderful world of spreadsheets!

B Wishes


Tim F