How do I sum up two different columns within a subform?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

JohnnyF - 28 Aug 2006 23:14 GMT

I have two columns in a subform for an invoicing system, LineTotal and
CostLineTotal. When I use the sum command, i.e. Sum([LineTotal]) once in the
footer it works fine but when I try Sum([CostLineTotal]) aswell, errors come
up with both summations. Both work fine when I cut out the other one but I
want the two to work simultaneously

Reply to this Message

Sue Mosher [MVP-Outlook] - 28 Aug 2006 23:19 GMT

Footer? Outlook forms don't have footers. Maybe you're thinking of Access?

Signature

Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003
http://www.turtleflock.com/olconfig/index.htm
and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx

>I have two columns in a subform for an invoicing system, LineTotal and
> CostLineTotal. When I use the sum command, i.e. Sum([LineTotal]) once in the
> footer it works fine but when I try Sum([CostLineTotal]) aswell, errors come
> up with both summations. Both work fine when I cut out the other one but I
> want the two to work simultaneously

Reply to this Message

JohnnyF - 28 Aug 2006 23:39 GMT

Apologies. I put the question in the wrong section. It is Access I'm talking
about

> Footer? Outlook forms don't have footers. Maybe you're thinking of Access?
>
[quoted text clipped - 3 lines]
> > up with both summations. Both work fine when I cut out the other one but I
> > want the two to work simultaneously

Reply to this Message