Running sum problem

[skwilliams]

I have a tabular form for which I need running totals at the bottom. The referenced fields in the form are Integer data type.

I created unbound fields in the form footer as Integer data type also.

I'm using =Sum([Field1]) in the control source of the unbound fields where [Field1] is the name of the referenced field in the form.

When I go to form view the unbound fields show #Error.

What am I doing wrong?

 

[FoFa]

Use DSUM agregate function, loko it up in HELP

 

[skwilliams]

The DSum function asks for criteria. I have no criteria to specify. I just want the total of each field.

Something odd I've noticed if I set the sum for just one field the sum function works. If I try to sum two fields they both receive the #Error.

 

[FoFa]

Criteria is optional in the DSUM function according to help. Also if a value changes you need to requery your unbound forms so it will sum again.

 

[skwilliams]

When I try to use the Dsum function, I receive this error.

The expression you entered has a function containing the wrong number of arguments.

 

[Rich]

Is field1 a calculated control?

 

[skwilliams]

No, Field1 is bound to the table

 

[Rich]

Since Sum([Field1]) works on its own, there is an error referencing one of the other fields