Calculations/formulas

[RFM]

Problem: How do you created a formula in a column of a
table.
Table is expense
I need to verifiy that my breakdown of the expense item
balances with the total of the expense.

Total Expense minus Breakdown
Example:
Total Expense 100.
Breakdown: Gas 20 Entertainment 20 Supplies 60

Display results in Verification Column.

If verification column does not equal zero. Force me to
correct before continuing to the next record or exit.

Thank you for your help, RFM

 

[Kevin3NF]

--
Kevin Hill
President
3NF Consulting

www.3nf-inc.com/NewsGroups.htm

Problem: How do you created a formula in a column of a
table.

You don't. You create a formula either in a query or in a control on a
form. Do not store data in a table that can be calccute whenever you need
it.

Table is expense
I need to verifiy that my breakdown of the expense item
balances with the total of the expense.

Total Expense minus Breakdown
Example:
Total Expense 100.
Breakdown: Gas 20 Entertainment 20 Supplies 60

Display results in Verification Column.

If verification column does not equal zero. Force me to
correct before continuing to the next record or exit.

Are you entering data directly into the tables? Bad idea. Please use a
form for this...that is what they are there for.