Add two Fields

[ragha]

Hi



As i posted earlier I am trying to add two premium fields but i m getting #Error.

I am trying to add two premiums which are in the form,and what i observed is all the form fields are stored in master table.
My question is how can i add this values and display on the report in Access 2003?

Thanks

[TheShabz]

are you doing it in a query?

UPDATE mytable
SET field3 = field1 & field2

if you want a space between them it would be
field3 = field1 & " " & field2