Calculated field in query or report output

[Keefay78]

Hi folks, I am trying to create a report with hours worked, I created a query to select the staff member and the job and has calculated the hours worked, now I would like to get a total for that person.

I have tried calculating fields in a query but I get no output, I think i must be close but not close enough, I tried creating a field within the query (called it adjustment) to sum the OpHours field in the query but it just displays the same output as OpHours when I need the total of that field, I am getting errors with my textbox for the output on the report



I am at my wits end, up until now I have managed to get this far but I am completely stuck, any help would be greatly appreciated

[alansidman]

You probably need to create a group by Query. Here is a link on how that works.

https://www.techonthenet.com/sql/group_by.php

[Micron]

Did you turn on "sorting and grouping" in design view? Could be as simple as performing a sum over group. I prefer to do such calculations using report options when possible.