form formula to combine two fields

[InvGrp]

I've been trying (with no luck) to combine two fields in a form.

The 1st field is TD1 and the 2nd is TD2.

I've tried all type of combinations but none of them work except for the following:

=[TD1] + [TD2]

The contents of these fields are 10 and 20 respectively.

BUT, it creates 1020 and I'd like the results to be 30 (add them together) instead.

I've looked all over the place but can't find anything that addresses this.

I also tried to do this within the query by adding a new field TD1TD2 but I also couldn't figure out how to get that to work.

Any help would be appreciated.



Bruce

[iandarkwater]

Access thinks your fields are text which is why as text

10+20=1020

Change them to numeric fields & =[TD1] + [TD2] in a text box on a form will sum correctly as will

YourSum:[TD1] + [TD2]

in a query

Best of Luck

ian