Calculations/formulas

  • Thread starter Thread starter RFM
  • Start date Start date
R

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
 
Create a Query based on the Table, there you can create a new column
with the format

NAME: [FIELDNAME] * 2

Which will multiply the field with the indicated field name by 2 in a
new column called "NAME"

The help file has many examples as does the sample database(s)
 
--
Kevin Hill
President
3NF Consulting

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

RFM said:
Problem: How do you created a formula in a column of a
table.
Click to expand...
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.
Click to expand...
Are you entering data directly into the tables? Bad idea. Please use a
form for this...that is what they are there for. :-)
 
Back
Top