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

[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.

 

[Rick B]

You would do this in your FORMS, not your tables. Tables should not store
calculated values, just the fields that make up those calculations.

 

[Duane Hookom]

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.

 

[Rick Brandt]

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.

 

[Jeff Boyce]

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>