Implementing Math Formula

[cwwaicw311]

Hi, how to implement a math formula involving 4 item. The column in wat i am doing are Current balance, receive, issue out, new balance. The formula would be current balance add receive minus issue out and equal to new balance. How and where should i put this formula.

[RuralGuy]

If this is in a table then you should *not* do it there. I would do it is a query of the table.

[cwwaicw311]

Actually, i'm not doing it in a table. I'm doing it in a form, whereby when i enter a value into the field mention then the calculation will be executed and the both the value i type in and the final answer will also appear at the table. The form is where the value is type in and the table is just a record only. That why i not sure how to implement the formula.

[RuralGuy]

As I said, it is not wise to store calculated values in a table. You can do the calculation on a form or in a query but why do you feel you need to keep the results in a table?

[jbarrum]

Are you storing the in/out items in the same field as positive/negative numbers? If I think you could get what you want from using sum function in an unbound control on your form

[cwwaicw311]

The data is store in four field in the form "Current balance, receive, issue and new balance". So i need to create a math formula in the form where Current balance + Receive - Issue = New balance. All the value for Current balance, receive and issue will be enter in the form and the New balance will appear on the New balance field after the calculation.

[RuralGuy]

The data is store in four field in the form "Current balance, receive, issue and new balance".

So the first three pieces of data are not in a table, right?

[cwwaicw311]

Yup, the first 3 data is not in the table. The 3 data will straight enter into the form. Then after the data is enter the math calculation will automatically perform n show the final value in the New balance field.

[RuralGuy]

So the ControlSource of the NewBalance control will be:
=Nz(Me.[Current balance],0) + Nz(Me.Receive,0) - Nz(Me.Issue,0)

[cwwaicw311]

I try the formula already, but it is not working and on my new balance field before i type in anything there appear a word like tis " #Name? "

[RuralGuy]

What are the actual names of the three controls? It is the 1st row on the Other tab of the property sheet for each control.

[cwwaicw311]

I change all 3 control into CurrentBalance, Receive and Issue and also use the same name on the formula u sent me. But still got the #Name? on the NewBalance field.

[RuralGuy]

Maybe you need to post the db, or at least a sample of it with the problem.

[cwwaicw311]

This is the Access file which i am doing. Maybe you can take a look at it to see what is the problem. Thank.

[RuralGuy]

Try this one. I removed the Me. from the formula.