[AccessD] Sum of a Row

Susan Harkins ssharkins at gmail.com
Sat Apr 16 18:25:18 CDT 2022


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



More information about the AccessD mailing list