|
| 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
July 13th, 2009, 12:07 PM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
counting yes or no
i put "=Sum(Abs([YourCheckBox])" in controlsource but it is not working.How
can i do it right.plz help. 
|
|
#2
July 13th, 2009, 12:16 PM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
|
counting yes or no
Control Source of what? In what way is it not working? What are you trying
to sum? "count yes or no" count yes or wrote in message ... i put "=Sum(Abs([YourCheckBox])" in controlsource but it is not working.How can i do it right.plz help.
|
|
#3
July 13th, 2009, 01:40 PM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
|
counting yes or no
There is nothing to sum in a control source. Only one record is presented at
a time. Perhaps if you can explain WHAT you want to do, we can help with the HOW to do it. -- Dave Hargis, Microsoft Access MVP "count yes or no" wrote: i put "=Sum(Abs([YourCheckBox])" in controlsource but it is not working.How can i do it right.plz help.
|
|
#4
July 13th, 2009, 03:55 PM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
|
counting yes or no
Also you have two opening but only one closing parenthesis.
-- Build a little, test a little. "count yes or no" wrote: i put "=Sum(Abs([YourCheckBox])" in controlsource but it is not working.How can i do it right.plz help.
|
|
#5
July 13th, 2009, 06:19 PM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
|
counting yes or no
Hi,
in the control source property of a control on a form or report you have to use a domain function, I suppose you could use something like: = DCount("[MyYesNoField]";"[TableName]"; "[MyYesNoField] = -1") -- Kind regards Noëlla "count yes or no" wrote: i put "=Sum(Abs([YourCheckBox])" in controlsource but it is not working.How can i do it right.plz help.
|
|
#6
July 13th, 2009, 08:01 PM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
|
counting yes or no
The expression using Sum and Abs would do the same thing, as long as it has
enough closing parentheses, as Karl pointed out. "NG" wrote in message ... Hi, in the control source property of a control on a form or report you have to use a domain function, I suppose you could use something like: = DCount("[MyYesNoField]";"[TableName]"; "[MyYesNoField] = -1") -- Kind regards Noëlla "count yes or no" wrote: i put "=Sum(Abs([YourCheckBox])" in controlsource but it is not working.How can i do it right.plz help.
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
