DCount with multiple criteria (1 Viewer)

[Lkwdmntr]

Can anyone see what I'm doing wrong with this one?

DCount("[WeeklyPlanID]", "tblWeeklyPlans", "[UserIDFK] = " & lngUserID & " AND [StatusFK] <> " & 'New')

I tried the New in double-quotes too.

 

[theDBguy]

Can anyone see what I'm doing wrong with this one?

DCount("[WeeklyPlanID]", "tblWeeklyPlans", "[UserIDFK] = " & lngUserID & " AND [StatusFK] <> " & 'New')

I tried the New in double-quotes too.

Maybe try it this way.

DCount("*", "tblWeeklyPlans", "[UserIDFK] = " & lngUserID & " AND [StatusFK] <> 'New'")