Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Date comparison
I'm trying to do something very similar to this. I need to generate a report based upon committed effort. For example, an employee has agreed to commit 50% of his time to a project with an effective start date of 1/1/07 and an effective end date of 12/31/10. I would like the report to show a...- fergler
- Post #8
- Forum: Microsoft: Access Other topics
-
Creating a 5 year projected revenue report
Skip: Thank you for responding. The basic query I created uses the following information/calculations: Account Budget Date: 1/1/07-12/31/07 Fiscal Year: 9/1/06-8/31/07 Account Budget: 100,000 Number of months for the account budget: 12 Since the Account budget date has a start date > than...- fergler
- Post #3
- Forum: Microsoft: Access Other topics
-
Creating a 5 year projected revenue report
I've been asked to creat a report that will project grant revenues for a 5 year period. Our fiscal year runs 9/1-8/31, but grants have start dates that might begin during the middle of a fiscal year. If a grant has a start date of 1/1/07, then 8 months of the revenus fall in fisal year 2007...- fergler
- Thread
- Replies: 2
- Forum: Microsoft: Access Other topics
