[AccessD] Sum of a Row

[Rocky Smolin]

Paul:

Query worked - with a little encouragement.  I found that when summing
numbers from fields you have to use NZ because if there's one number in the
list that's null lthe sum is null as well.

Thanks for the lead.

Rocky


On Sat, Apr 16, 2022 at 3:54 PM Paul Hartland via AccessD <
accessd at databaseadvisors.com> wrote:

> 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
> >
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> https://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>