|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
November 29th, 2009, 06:28 AM
posted to microsoft.public.access.forms
|
|||
|
|||
Total only specific records on a continuous form
I am trying to add a total to the form footer on a continuous form that will
only total the records marked with a check box field. Is there a way to specify this in the control source on the total field. For example, I have 4 records displayed on my form and 3 are marked. I only want to total the value for the 3 marked records in my total line. 
|
|
#2
November 29th, 2009, 06:49 AM
posted to microsoft.public.access.forms
|
|||
|
|||
|
Total only specific records on a continuous form
On Sat, 28 Nov 2009 22:28:02 -0800, str8trini wrote:
I am trying to add a total to the form footer on a continuous form that will only total the records marked with a check box field. Is there a way to specify this in the control source on the total field. For example, I have 4 records displayed on my form and 3 are marked. I only want to total the value for the 3 marked records in my total line. Using an Unbound control: =Sum(IIf([CheckBox] = -1,[FieldToBeSummed],0)) -- Fred Please respond only to this newsgroup. I do not reply to personal e-mail
|
|
#3
November 29th, 2009, 07:37 AM
posted to microsoft.public.access.forms
|
|||
|
|||
|
Total only specific records on a continuous form
Perfect. Thank you so much!!!
"fredg" wrote: On Sat, 28 Nov 2009 22:28:02 -0800, str8trini wrote: I am trying to add a total to the form footer on a continuous form that will only total the records marked with a check box field. Is there a way to specify this in the control source on the total field. For example, I have 4 records displayed on my form and 3 are marked. I only want to total the value for the 3 marked records in my total line. Using an Unbound control: =Sum(IIf([CheckBox] = -1,[FieldToBeSummed],0)) -- Fred Please respond only to this newsgroup. I do not reply to personal e-mail .
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
