Sum in report using text box

[rockiwood]

I hope what I have is an easy question.
I have a report that gives overtime hours sorted by Category of Overtime (Category A, ,B, C...thru F.) and type of employee (Sworn or Civilian)under each category.

Under each category and type of employee, there is a total of the hours for employee type and a total for the category.

What I am trying to do is list the total hours for each employee type and category type for the whole report at the end of the report. I am trying to do this in a text box.

While not being the best with Access, I don't know the correct format for this.

I tried this for one of the text boxes:
=Sum([hoursworked]![fldsworncivilian]="sworn" And [category]="Category A - Required to meet minimum manpower requirements")

Obviously, it didn't work.

Any help is appreciated

I hope I have explained this okay.

Thanks in advance

Jerry

 

[dhookom]

I would create a totals query that displays the exact totals needed for the report footer. Then make a subreport based on the totals query and stick the subreport in the main report's Report Footer section.

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]

 

[rockiwood]

I'll give that a try.

Jerry