Changing total on one row in Continous Form
in [Forms]
|
Prev: DLookup with mulitple criteria - error message
Next: Send Appointments from Access 2007 to someone else's Outlook Calen
From: Cathy on 7 Apr 2010 16:37 In Access 2007, I have a continous form, and I only want to update the row total of the record I am on. How do I update only the one row total, and not all row totals? Thank you,
From: John W. Vinson on 7 Apr 2010 18:35 On Wed, 7 Apr 2010 13:37:01 -0700, Cathy <Cathy(a)discussions.microsoft.com> wrote: >In Access 2007, I have a continous form, and I only want to update the row >total of the record I am on. How do I update only the one row total, and not >all row totals? > >Thank you, What is a "row total"? That's not an Access construct; it would seem to be something you've added. And if it's a calculated field based on values in the record, what do you mean by wanting to update it? Do you mean that you want to have 2 + 2 equal to 4, except sometimes you want to have it equal to 13 instead??? -- John W. Vinson [MVP]
From: Cathy on 7 Apr 2010 19:31 John, I know this sounds unusual. Yes it is a created total on the row. They want the amount to update only if approved. They do not want all rows to update. Just the one they are approving, when they are approving it. How do I go about doing this? Thank you, Cathy "John W. Vinson" wrote: > On Wed, 7 Apr 2010 13:37:01 -0700, Cathy <Cathy(a)discussions.microsoft.com> > wrote: > > >In Access 2007, I have a continous form, and I only want to update the row > >total of the record I am on. How do I update only the one row total, and not > >all row totals? > > > >Thank you, > > What is a "row total"? That's not an Access construct; it would seem to be > something you've added. And if it's a calculated field based on values in the > record, what do you mean by wanting to update it? Do you mean that you want to > have 2 + 2 equal to 4, except sometimes you want to have it equal to 13 > instead??? > -- > > John W. Vinson [MVP] > . >
From: John W. Vinson on 7 Apr 2010 19:57 On Wed, 7 Apr 2010 16:31:02 -0700, Cathy <Cathy(a)discussions.microsoft.com> wrote: >John, > >I know this sounds unusual. Yes it is a created total on the row. They >want the amount to update only if approved. They do not want all rows to >update. Just the one they are approving, when they are approving it. > >How do I go about doing this? I don't know, because I still have no idea what the "total row" is or how you're calculating the total, nor what the "update" might involve. More info please? What's the control source of the "created total" control? -- John W. Vinson [MVP]
From: Cathy on 8 Apr 2010 07:40
John, The continous form shows one record (row) per section. The total is a field, per section that needs approval (flag) before it can be updated. I've tried creating an if statement ( if approval = "Y" then sum(a+b)), but it keeps updating all records... not just the record that I am on. What can I do to have it only update the record that I am on? Thank you again, Cathy "John W. Vinson" wrote: > On Wed, 7 Apr 2010 16:31:02 -0700, Cathy <Cathy(a)discussions.microsoft.com> > wrote: > > >John, > > > >I know this sounds unusual. Yes it is a created total on the row. They > >want the amount to update only if approved. They do not want all rows to > >update. Just the one they are approving, when they are approving it. > > > >How do I go about doing this? > > I don't know, because I still have no idea what the "total row" is or how > you're calculating the total, nor what the "update" might involve. More info > please? What's the control source of the "created total" control? > > -- > > John W. Vinson [MVP] > . > |