Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Database Design / January 2004

Tip: Looking for answers? Try searching our database.

calculating fields

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
sander - 15 Jan 2004 13:20 GMT
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 - 15 Jan 2004 17:46 GMT
> 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
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.