Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / General MS InfoPath Questions / August 2005

Tip: Looking for answers? Try searching our database.

Summarising/Totalling Columns

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Markos - 11 Aug 2005 16:25 GMT
I'm new to Infopath and need to know if the following is possible and
some guidence on how to do it.....

I'm creating a timesheet to record each job I complete for a company
and what cost center within that company to charge to.  I then need to
have a summary of the weeks work for each comany and cost center in a
table to present to Payroll.   I have gotten as far as using a
repesting table to add a new line for each job but can't work out how
to group then summarise the time.
Also, can you have a dropdown selection within a repeating table?
JerryTh [MSFT] - 12 Aug 2005 18:25 GMT
Drop Down list boxes are perfectly happy in a Repeating Table.

You can put summary field in the table footer or outside of table altogether.
Add a function to text box.
Insert Function = 'Sum' and then select the column you want totaled.
You will need to do your time calculations in script. The built in functions
don't handle times and dates very well.

Signature

This posting is provided "AS IS" with no warranties, and confers no rights.
Sample code subject to http://www.microsoft.com/info/cpyright.htm
Do not send email to this alias. It is for newsgroup only

> I'm new to Infopath and need to know if the following is possible and
> some guidence on how to do it.....
[quoted text clipped - 6 lines]
> to group then summarise the time.
> Also, can you have a dropdown selection within a repeating table?
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.