Sum Function as Control Source

T

Troy W.

I am working on a purchase order database. I am trying to get a subtotal for
an order. The code I am using for the control source for the subtotal is:

=sum([LineTotal])

It gives me an #Error. Any ideas?

Thanks,

Troy W.
 
R

Rick Brandt

Troy said:
I am working on a purchase order database. I am trying to get a
subtotal for an order. The code I am using for the control source
for the subtotal is:

=sum([LineTotal])

It gives me an #Error. Any ideas?
Click to expand...

Where did you put this control? Assuming this is a continuous form it needs
to go in the Form's footer or header section.
 
Top