SUM FUNCTION

[Guest]

I am very new to data base design and functions. I have two fields and I
would like to add it up so that third field dispalys the sum of the two
prevoius fields. E.g

FIELD 1
BASE PRICE: $ 10

FIELD 2
MARK UP: 10%

FIELD 3
I would like the sum total of Field 1 + Field 2 = $ 110 in Field 3.

I know how to do this Excel. Could someone help me with Access please?

Thank you

Prasad

 

[Guest]

You say fields? Fields are associated with tables, are you saying you have
three fields in a table and want the third field to be the sum of the first 2?

If so, you cant do it, tables are for storing data only, your calculations
must be performed in queries or forms and are rarely required to be pasted
back to tables as the data is always changing.

If however you are talking about the controls on a form and field1 and
field2 are boxes, then you can use a third unbound control to do the sum. In
the control source row of the properties for the unbound control type,
=[field1]+[Field2]

The same applies for a query which could give you the third control on a
form Field3:[field1]+[Field2].

Hope this helps, post back if not

Kindest regards

Mike B

--
An Engineers Prayer:
At the very end of the day,
when all else fails,
you have tried all,
you have shouted at and blamed the innocent,
and asked everyone you know,

READ THE INSTRUCTION MANUAL.