How can I add more than 2 text box values?

[Gabriello]

I am working on an accounting database with differening exchange rates. I
have been attempting to create one text box with a balance value after using
the correct exchange rate.

For instance I have Box1 = 2345.00 pesos and Box2 =2,100.00 (exchange rate)
and I have Box3 with a dollar ammount. How do I divide Box1 by Box2 and add
Box3 for a Balance, that I can use in a report or in an other table.

I've tried using =sum([Box1]/[Box2]+[Box3]) on the form side, and on the
query side but it gives me an error. and I still don't know how to label it
to be used by a report or to be used within a table to maintian an actual
balance.

 

[Marshall Barton]

I am working on an accounting database with differening exchange rates. I
have been attempting to create one text box with a balance value after using
the correct exchange rate.

For instance I have Box1 = 2345.00 pesos and Box2 =2,100.00 (exchange rate)
and I have Box3 with a dollar ammount. How do I divide Box1 by Box2 and add
Box3 for a Balance, that I can use in a report or in an other table.

I've tried using =sum([Box1]/[Box2]+[Box3]) on the form side, and on the
query side but it gives me an error. and I still don't know how to label it
to be used by a report or to be used within a table to maintian an actual
balance.

The aggregate functions (Count, Sum, etc) only operate on
field in the form/report's record source table/query. THe
are ubaware of controls on a form/report.

How did the text boxes' get their value? If they are bound
to fields in the record source, then use the field names
instead of the control names.