Thanks John i found the problem... I noticed in the query that i don't have single qoutes( ' ) to my dates. Got it fixed now.

And when i add WHERE Clause i get the error "Operand type clash: date is incompatible with int" not sure whats causing the issue why i get that error.

All i...

this is what i want to achieve. In here i had problems regarding how to change null to 0, i tried using ISNULL or COALESCE and its not working gotta...

Hi john this is my table.