Boolean in Query

[Khartoum]

I have a query counting the number (sum) of ticks in a column i.e. yes/no
data type. For each column, it is returning the numbers with a minus in front
of it (obviously summing the -1's boolean). Is there a way around it
cheers John

 

[Jeanette Cunningham]

Switch the query to SQL view. Copy what you see in SQL view and paste into a
reply and post back here, so we can see why you are getting numbers with -1.

Jeanette Cunningham

 

[Allen Browne]

Since Access (JET) uses -1 for True (and zero for False), summing a yes/no
field will give the negative of the count of checked boxes.

You can quite easily negate the result. In SQL View (View menu) of your
query, where it says:
SELECT ... Sum(MyYesNo) AS SumOfMyYesNo, ...
change it to:
SELECT ... - Sum(MyYesNo) AS SumOfMyYesNo, ...

 

[Khartoum]

Thanks Allen, simple when you know how - not great user of SQL but this
proves i should be