How do I add 3 fields in a form?

[jimrawr]

Hey everyone, I am really new to access and im trying to do something that is probably fairly simple for you guys..

I have a form setup, and I need one of the fields to simple add up 3 other fields. I.E fixed expenses + variable expenses + misc expenses = total expenses..

How do I do this? I figure out how to do it in a query by doing totalexpenses: [field1]+[field2]+[field3]

but how do I do it in a form?

Thanks in advance

 

[TheAceMan1]

How are ya jimrawr . . .

Set the [blue]ControlSource[/blue] property of an [blue]unbound Textbox[/blue] to:

[blue] =[field1]+[field2]+[field3][/blue]

See Ya! . . . . . .

 

[jimrawr]

Another thing... is it possible to do it just in the table? where would I put in the code for the field?

 

[Lilliabeth]

No. You cant do math in a table. Think carefully about whether you want to anyway. One major goal of a relational database is to eliminate the storage of redundant info. Why store data that can be gleaned from other data? You may need to display it, but do you need to store it?

 

[missinglinq]

Popular wisdom states that you never store calculated data in a table, but as Lilliabeth notes, you need to think about this. If all factors in the calculation will remain the same (such as POUNDS X 16 = OUNCES)then they shouldn't be stored in the table. If any factor could change in the future,however, such as the price per pound (POUNDS X $1.59 becomes POUNDS X $1.89) then the calculated price needs to be entered in the table.

The Missinglinq

There's ALWAYS more than one way to skin a cat!