 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Database Design / June 2005How do I create Mathamatical Equations in the Fields of a Table
If anyone can help me I appreciate it. I am creating a new database, and I want to set up some equations that will automatically take place when I imput the money value. You would do this in your FORMS, not your tables. Tables should not store calculated values, just the fields that make up those calculations.  SignatureRick B > If anyone can help me I appreciate it. I am creating a new database, and I > want to set up some equations that will automatically take place when I imput > the money value. You shouldn't normally store calculated values in tables. You can use queries and other methods to "display" calculated values. You can't perform calculations in tables. SignatureDuane Hookom MS Access MVP -- > If anyone can help me I appreciate it. I am creating a new database, and I > want to set up some equations that will automatically take place when I > imput > the money value. > If anyone can help me I appreciate it. I am creating a new database, > and I want to set up some equations that will automatically take > place when I imput the money value. You don't put those in a database table. Build a query base on your table and then add the calculations as expressions in the query. Then just use the query instead of the table. SignatureI don't check the Email account attached to this message. Send instead to... RBrandt at Hunter dot com In addition to the other suggestions you've received, I wonder if you are describing a spreadsheet, rather than a relational database. Spreadsheets are great for taking input values and performing calculations/equations... Good luck Jeff Boyce <Access MVP> > If anyone can help me I appreciate it. I am creating a new database, and I > want to set up some equations that will automatically take place when I imput > the money value. |
Reply to this Message |
 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.