[AccessD] Sum of a Row

[Rocky Smolin]

No - no maintenance. But there are some other complexities to the form. But
that part is done. It will be one of two subforms that need to align
correctly to look like one form. But no maintenance - read only.  Makes
life a bit simpler.

r

On Sat, Apr 16, 2022 at 6:56 PM Stuart McLachlan <stuart at lexacorp.com.pg>
wrote:

> If he wants a form that just SHOWS the data, then normalised tables and a
> crosstab query
> are the way to go.
>
> If he wants to do data maintenance then yours is the viable solution.
>
>
> On 16 Apr 2022 at 15:44, Rocky Smolin 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
> >
>
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> https://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>