I am using ADO to access an access database. I am trying to do a count of records where a value is not null. What is the exact sytax for that ?

What I have is :
Code:
"select count(*) from Table where Field1='Some Value' and Field2 is not null"
Field1 is a string and Field2 is a long integer.

Any ideas ?... what am I doing wrong ?