Problems with checkboxes

[simonI]

i have checkboxes on a form and want to run a query based on the amount of times the checkbox(es) have been selected...

i have done this and attached a report however because the value of the checkboxes is -1 obviuosly the sum of this is a negative number and so on the report the total selcted is negative....

is there a way to change these to positive numbers...

and if so where do you put it.

cheers in advance

Si

 

[KenHigg]

Just put it in the abs() function?

 

[simonI]

yes i thought that - similar to excel - but i havent the foggiest where to put it...

 

[reclusivemonkey]

but i havent the foggiest where to put it...

You can place it either in the query your report is based on, or in the report itself.

Report Field:

=Abs([YourChkBoxField])

Query Field:

YourFieldName: Abs([YourChkBoxField])

 

[simonI]

i have created both of these using the wizard.. and i cant find anywhere to put the code....

i have tried to use the expression builder in the control source of where the number appears on the form but it keeps giving me syntax errors

this is a portion of the SQL code that the query uses..

SELECT DISTINCTROW Sum([Module selection Table].[International Business 1]) AS [Sum Of International Business 1], Sum([Module selection Table].[Business Programming 1]) AS [Sum Of Business Programming 1],

is there an easier way

 

[reclusivemonkey]

D'OH I just though. Why not use "COUNT"?

 

[simonI]

thanks i sorted it by just multiplying the SQL sum thingy by -1 and it seems to work..