adding data

[stevie1969]

Another simple question

I have 2 fields income and expenditure

i have a 3rd field disposable income

how do I get disposable income to automatically change when I input income and expenditure in a form

many thanks

 

[weilerdo]

The easiest way would be to have 3 fields in your query field 1 would be income, field 2 would be expenditure
and the third field would be an expression

Example: of the 3rd field would be: disposable[income]-[expenditure]) which will give you a calcutated total.

Hope that helps

 

[Michael J Ross]

Or in the Data Source for Disposable Income field use =[Income]-[Expenditure]

 

[stevie1969]

weilerdo

I have set up a query to work out the difference but that does not seem to help when I am inputting on the form.


Michael J Ross

if i change the control source of disposable income to income - expenditure it updates on the form but does not store the result in the field disposable income.

 

[Michael J Ross]

Do you need to store disposable income in your table?

If you search through this forum it is always advised not to store calculated amounts.

 

[stevie1969]

really?

Basically I wanted to have a box on the form that would update as I typed in the data and I can do that using the formula you gave me.

But I then thought that I could search on this data to find who has a disposable income more than such and such, although I suppose I could just use a query on the input fields.

why is the advice not to store the data?

I better try and search

 

[ansentry]

Have a look at the attached.