|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Search this Thread | Display Modes |
|
|
|
#1
August 28th 06, 11:14 PM
posted to microsoft.public.outlook.program_forms
|
|||
|
|||
How do I sum up two different columns within a subform?
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 
|
|
#2
August 28th 06, 11:19 PM
posted to microsoft.public.outlook.program_forms
|
|||
|
|||
|
How do I sum up two different columns within a subform?
Footer? Outlook forms don't have footers. Maybe you're thinking of Access?
-- 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 "JohnnyF" wrote in message ... 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
|
|
#3
August 28th 06, 11:39 PM
posted to microsoft.public.outlook.program_forms
|
|||
|
|||
|
How do I sum up two different columns within a subform?
Apologies. I put the question in the wrong section. It is Access I'm talking
about "Sue Mosher [MVP-Outlook]" wrote: Footer? Outlook forms don't have footers. Maybe you're thinking of Access? -- 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 "JohnnyF" wrote in message ... 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
|
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Sum time in Outlook Calendar | [email protected] | Outlook - General Queries | 1 | September 12th 06 12:18 PM |
| sum messages belonging to folder | Mark | Outlook Express | 7 | June 4th 06 10:55 PM |
| renaming columns | AJS | Outlook Express | 6 | May 16th 06 09:04 PM |
| sum of columns | manish chulawala | Outlook - Using Forms | 1 | April 7th 06 12:17 PM |
| Sum up overtime hours for my sent mails over one year | Qiubang Li | Outlook and VBA | 1 | March 6th 06 08:01 AM |
Hybrid Mode
