Solved Cumulative sum of form text boxes (1 Viewer)

chizzy42

Registered User.
Local time
Today, 05:46
Joined
Sep 28, 2014
Messages
53
Hi, Could someone point me in the right direction here. From a query I've made a report that works ok
and gives the relevant data. see below
rpt.png

as you can see the pass and fail columns in the current total sum as new data is passed each hour using the the report function ..Running sum > over group.
The issue is id like to also have a form that i can add various addons . My problem is is cant get the text boxes to be a running total on the form.
frm.png

is there a function similar to the report Running sum > over group or is it going to be more code based to achieve this.

Thanks for any help
 

mike60smart

Registered User.
Local time
Today, 05:46
Joined
Aug 6, 2017
Messages
837
Hi, Could someone point me in the right direction here. From a query I've made a report that works ok
and gives the relevant data. see below
View attachment 93134
as you can see the pass and fail columns in the current total sum as new data is passed each hour using the the report function ..Running sum > over group.
The issue is id like to also have a form that i can add various addons . My problem is is cant get the text boxes to be a running total on the form.
View attachment 93135
is there a function similar to the report Running sum > over group or is it going to be more code based to achieve this.

Thanks for any help
Which Field are you trying to get the Total for?
 

arnelgp

once i caught a fish alive...
Local time
Today, 12:46
Joined
May 7, 2009
Messages
13,193
use DSum() on your Query so that it will make your query Updateable.
see Query1 in design view.
 

Attachments

  • passFail.accdb
    448 KB · Views: 7

Users who are viewing this thread

Top Bottom