is dbnull error in asp.net sql "Invalid user of IS operator" 1

[greenbird]

I get an error message saying:

"Invalid use of Is operator in query expression "

when i use the IS DBNULL in the following sql statement in asp.net:

SELECT SUM(tblDailyHrs.TotSchHrs) AS TotalSch, SUM(tblDailyHrs.TotActHrs) AS TotalAct,
SUM(tblDailyHrs.OverTime) AS TotalOt, SUM(tblDailyHrs.AddHrs) AS TotalAdd, SUM(tblDailyHrs.TotTkActHrs) AS TotTkActHrs, SUM(tblDailyHrs.TkOtHrs) as TotTkOtHrs
FROM tblDailyHrs
WHERE tblDailyHrs.CostCtr = "PA00012"
AND tblDailyHrs.PeriodID = "25-2008"
AND tblDailyHrs.EmpNo = "71445"
AND (tblDailyHrs.ActEstAdj = "Act"
OR tblDailyHrs.ActEstAdj Is DbNull )
;

i am using MS Access as the back end. What am i doing wrong and how can i correct it?

 

[jmeckley]

check in forum701

Jason Meckley
Programmer
Specialty Bakers, Inc.

 

[ca8msm]

OR tblDailyHrs.ActEstAdj Is [!][s]Db[/s][/!]Null

[!]
-------------------------------------------------------

Mark,

Join me at the new IT Community of the 21st Century: [!][URL unfurl="true"]http://lessthandot.com[/!][/url]

[/!]

 

[greenbird]

ac3msm,

Your code modification to Is Null worked. Thanks a lot.

Regards,

greenbird