Adding two fields together and putting results in a third field

[Troubled]

I am an utter beginner using Access 2003. I have easily created a database but cannot make it do simple tasks. One task is to add two fields and put the result in a third field. It should be a terribly simple thing to do but seems to involve queries and macros and combo boxes etc. All the forums I have looked at provide no help because the instructions contain syntax errors and incomplete instructions. Please could anyone help me

[ranman256]

in a query,
MyNewTxtField: [field1] & [field2]

MyNewValue: [field1] + [field2]

[Missinglinq]

Since this is a Calculated Field, it should not be stored in a Table, but simply re-calculated , as needed. Since you're not storing it, you can use the Control Source of the third Textbox to do the math.

In Form Design View

• Right-Click on the 'results' Textbox
• Click on Properties
• Click on the Data Tab
• In the Control Source Property enter this: = Nz([Textbox1],0) + Nz([Textbox2],0)

Of course you'll have to replace Textbox1 and Textbox2 with your actual names of your Textboxes.

The above assumes that when you said 'add two fields' you actually meant 'add,' in the mathematical sense. If you meant 'add two fields' as in adding ABC to DEF and getting ABCDEF, the Control Source would be slightly different:

=[Textbox1] & [Textbox2]

Linq ;0)>

[Troubled]

Thank you so much. That's perfect and just what I wanted. I really do appreciate your help.

[Missinglinq]

Glad we could help!

Welcome to AFN!

Linq ;0)>