[AccessD] Sum of a Row

[Bill Benson]

I remember doing this way back with a combination of cross tabs that I
would run one query in vba to get the data to set as criteria in a second
(cross tab) query then insert into a table and show the results on a form.

All a blur now, I would need a gun to my head to recreate it. I tried some
years later and couldn’t get it to work ever again. Sigh.

On Sat, Apr 16, 2022 at 7:30 PM Rocky Smolin <rockysmolin2 at gmail.com> wrote:

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