Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 10-04-2010, 03:32 AM
602chrislys 602chrislys is offline Total Resources Windows XP Total Resources Office 2003
Novice
Total Resources
 
Join Date: Oct 2010
Posts: 1
602chrislys is on a distinguished road
Default Total Resources

Hi Guys,

Im new to MS Project 2003 and cant seem to find a way of displaying the total number of resources on each of my tasks.



All I am looking for is a view or report that displays:

TASK | START DATE | END DATE | DURATION | NUMBER OF RESOURCES

Any help on acheiving this would be much appreciated!

Cheers.
Reply With Quote
  #2  
Old 10-04-2010, 09:04 AM
Kimberly Kimberly is offline Total Resources Windows 7 Total Resources Office 2010 (Version 14.0)
Expert
 
Join Date: May 2010
Posts: 517
Kimberly is on a distinguished road
Default

Add the field Number 1 to a table.

Use the following custom function:
Sub ResCount()
Dim t As Task
For Each t In activeproject.Tasks
If Not t Is Nothing Then
t.Number1 = t.Assignments.count
End If
Next t
End Sub
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Table of Content Eat up RAM Resources Tommy Word 0 08-23-2010 10:08 PM
Shared resources ediez Project 0 08-18-2010 12:04 PM
How to handle resources that have Bid on project rrmccabe Project 0 03-21-2010 12:39 PM
Total Resources FREE resources to learn M$ products... zyzzyva57 Office 4 05-16-2009 07:31 AM
Assigning resources. Sergey M Project 0 01-25-2006 09:33 AM

Other Forums: Access Forums - Senior Forums

All times are GMT -7. The time now is 08:12 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2020, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2020 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft