[AccessD] Sum of a Row

[Rocky Smolin]

thanks. got it figured out. mostly. for the moment. :o)

However, when I run into trouble with this one, I'll be back.


Rocky


On Sat, Apr 16, 2022 at 4:25 PM Susan Harkins <ssharkins at gmail.com> wrote:

> Would you consider posting a screenshot of this form somewhere and sending
> us a link?
>
> Susan H.
>
> -----Original Message-----
> From: AccessD <accessd-bounces+ssharkins=gmail.com at databaseadvisors.com>
> On
> Behalf Of Rocky Smolin
> Sent: Saturday, April 16, 2022 7:22 PM
> To: Access Developers discussion and problem solving
> <accessd at databaseadvisors.com>
> Subject: Re: [AccessD] Sum of a Row
>
> 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
> >
> --
> 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
>