Sum Function as Control Source

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Troy W. - 15 Apr 2005 16:29 GMT

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.

Reply to this Message

Rick Brandt - 15 Apr 2005 18:50 GMT

> 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
[quoted text clipped - 3 lines]
>
> It gives me an #Error. Any ideas?

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

Signature

I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com

Reply to this Message