I need assistance again please.
I received assistance with obtaining total hours based on another field being grouped. I have tried to sum up all of the total hours listed, but am not able to successfully sum up all of the total hours collected.
This worked in the query and shows well in the report:
I have tried to use the sum formula and making sure the the format of the field in the report footer would have the format of short time but using sum and the field give me either the first value in the list, or #Error in the field, or Data type mismatch in criteria expression.
The latest tried was:
The other fields used were easy to total in the Report footer. The total hours field just allows for Count Records and Count Values.
Thank you so much.