[AccessD] Sum of a Row

[Paul Hartland]

I am trying to remember back to what I used to do without much luck, but
one thing that springs to mind is building a query that corresponds to the
screen, adding the fields in the query and putting that total inside the
total field.

Paul

On Sat, 16 Apr 2022, 23:44 Rocky Smolin, <rockysmolin2 at gmail.com> wrote:

> Dear List(s):
>
> I have an app which keeps track of the number of students in a course. I
> have  form bound to a table which has 53 fields (one for each state plus
> D.C. Guam, and Puerto Rico) plus a field for the course number.
>
> Client wants a form showing the states across the top and courses down the
> left side. No problem. He also wants the total students at the bottom by
> state - no problem (=sum...etc.).
>
> He also wants the sum out on the right side of all the states' students for
> that course (row). Problem.
>
> a simple control source =state1 + state2 + state3... is too long. The field
> names are like fldISCD_State_AK, fldISCD_State_AL, fldISCD_State_AR, etc.
>
> I tried making a function called Summit which would some the fields and set
> the control source of the text box =Summit().  But it ain't workin'.
>
> So I'm having trouble figuring out how to get that row total in that last
> box. I think there must be a simple way to do that. But I've never
> encountered this requirement before so it ain't in my toolbox.
>
> Any ideas?
>
> MMTIA,
>
> Rocky
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> https://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>