SUM Function for varying amount of fields??????

[OrlandoG7]

I have a Subform in Mainform linked by JobNumber. Subform can have 1 or multiple textboxes with numeric value. I know how to make a Sum function on a constant amount of fields. But how do I do it when the amount of fields to be added varies? For example I know that if on fieldX I put: = [field1 + field2], I'll get the sum of field1 and field2. But what if the amount of fields to sum varies? And then how do I assign this value to fieldX in the mainform?

Any help is much appreciated. Orlando

 

[mac318]

Orlando,
Use the DSum function. There are some good examples in Access help.

mac

 

[OrlandoG7]

Will look. Thanks.