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

J

JohnnyF

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
 
S

Sue Mosher [MVP-Outlook]

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

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003

and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
 
J

JohnnyF

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

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

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003

and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers


JohnnyF said:
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
Click to expand...
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I sum up two columns in a subform? 4
Summing a calculated field 1
Returning fields from a combo-box 4
Summing in a subform 2
How do I set focus (and select text) on a text box on a modeless userform? 0
Calculation in SubForm 1
Comparing the sum of two columns with conditional formatting 0
Sum function on subform error 6

Top