I have a Task Report that identifies all of the tasks that my company performs over the course of the year. Some tasks are performed “D” for Daily, or 250 times per year; “7W” for 7 days per week, or 365 times per year; “M” for monthly, or 12 times per year, etc. I created the report that has headings as follows

• Frequency
• Task
• Building
• Floor
• Area

The report is grouped by Frequency and sorted by Task, Building and Floor. I want my report to automatically count the number of Daily tasks then multiply by 250; count the number of 7 days per week tasks, then multiply by 365; count the number of Monthly tasks, then multiply by 12, etc., so that I can have a total number of tasks that are performed during the course of the year.

Any help will be greatly appreciated.

Thanks,

David

David,
   This solution will work in the query for your report.

   iif([Frequency]="D", Count([Frequecy])*250, iif(Frequency=7W, Count([Frequency])*365))

   The code may not be exact, but you get the idea. Just keep adding iif statements for each of the frequency's you want to test for. I'm sure it can be done with in the query.

Hope this helps,
Mike