running total for each day

[NLR]

Hello,
I need some help with what I think is a running total for each day.
I have a form that collects data several times in the day.
I want a report to show a total for each day and subtotals for each column and grand totals.
I can add the dates and used a running total to the report but the report will show all the entries made for the day not a single total for the day. (I hope I said the correctly.) This needs to be done for all columns.
I'm not sure what I'm doing wrong. I've attached what I have so far.

Thanks for any help!
NLR

 

[JHB]

You need to make a Sum query and to remove the Id-field.
The change database is attached.

 

[NLR]

That's just what I needed. I never thought of using the sum in the query.
Still learning this stuff.
Thanks for your help!!!
NLR