setting up conditional logic in the summary area of a report

[MistyWolf]

We have generated a report to track employee time by department and by date range. Each employees time is tracked within the dept and each department has a total for all employees. Finally, there is a grand total at the bottom of the report of ALL departments.

My boss wants one of the departments that is listed in the department group to be left out of the total at the bottom of the report. Is there anyway to accomplish this?

Scott

 

[dhookom]

You can perform conditional sums in Footers and Headers. For instance, if you have fields:

LaborHrs numeric
Dept text

If you want to sum the LaborHrs for all Depts except "FINANCE", your calculation would be:

=Sum(Abs([Dept]<>"FINANCE") * [LaborHrs])

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]