How do I create Mathamatical Equations in the Fields of a Table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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.
 
Gov't of NL said:
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.
Click to expand...

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.
 
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>
 
Back
Top