var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Roulette Even/Odd/Red/Black Count problem
I'm working on a small acces db for tracking Roulette spins, but am having trouble with queries when trying to count only the even, odds, reds, and blacks.
I have one table called tblnumbers, with autonumber, gamenumber, and number fields.
Can anyone give me an idea of the query code for something like this?
Not sure exactly what you want, but:
SUM([value] Mod 2)
...will give you a count of the odd numbers, and so:
SUM(([value] + 1) Mod 2)
...will give you a count of the evens.