Home / QIN / projects

projects

Syndicate content
Your rating: None Average: 1 (2 votes)
More
Projects and Tasks
Projects and Tasks
October 25th, 2009 - 1:10 PM
0 comments
Tags:
More
How can I compare the current days elapsed for all open projects with the average completion time for all closed projects within that zip code? I want my report to display longer than average projects in red.

To achieve the results you are asking about, you will need to do the following:

1) Create a Zip Codes Table where each record is a Zip Code that will be assigned to your projects.
2) In the Zip Codes table, designate a Zip Code (text) field as the key field. (Normally Record ID#)

February 5th, 2009 - 6:02 PM
0 comments
Tags:
More
If I have a Projects table and a Tasks table where each Project record has many Task records how do I automatically indicate that the Project is completed when the "Status" field in all the related tasks are marked "Completed"?

Create two summary fields in the Projects table. The first summary field will be labled "Number of Tasks". It should be configured to count the number of Tasks. The second summary field should be labeled "Number of Completed Tasks". It should be configured to also count the number of related Tasks with a condition to include only the Task records where the "Status" field is "Completed".

February 5th, 2009 - 6:02 PM
2 comments
Tags:

© 1997-2013 Intuit Inc. All Rights Reserved.

Online Database VeriSign Secured Web Based Software TRUSTe Certification Online Database SSAE Audit