L Lkwdmntr Registered User. Local time Today, 00:15 Joined Jul 10, 2019 Messages 315 Apr 2, 2021 #1 Can anyone see what I'm doing wrong with this one? Code: DCount("[WeeklyPlanID]", "tblWeeklyPlans", "[UserIDFK] = " & lngUserID & " AND [StatusFK] <> " & 'New') I tried the New in double-quotes too.
Can anyone see what I'm doing wrong with this one? Code: DCount("[WeeklyPlanID]", "tblWeeklyPlans", "[UserIDFK] = " & lngUserID & " AND [StatusFK] <> " & 'New') I tried the New in double-quotes too.
theDBguy I’m here to help Staff member Local time Today, 00:15 Joined Oct 29, 2018 Messages 22,635 Apr 2, 2021 #2 Lkwdmntr said: Can anyone see what I'm doing wrong with this one? Code: DCount("[WeeklyPlanID]", "tblWeeklyPlans", "[UserIDFK] = " & lngUserID & " AND [StatusFK] <> " & 'New') I tried the New in double-quotes too. Click to expand... Maybe try it this way. Code: DCount("*", "tblWeeklyPlans", "[UserIDFK] = " & lngUserID & " AND [StatusFK] <> 'New'")
Lkwdmntr said: Can anyone see what I'm doing wrong with this one? Code: DCount("[WeeklyPlanID]", "tblWeeklyPlans", "[UserIDFK] = " & lngUserID & " AND [StatusFK] <> " & 'New') I tried the New in double-quotes too. Click to expand... Maybe try it this way. Code: DCount("*", "tblWeeklyPlans", "[UserIDFK] = " & lngUserID & " AND [StatusFK] <> 'New'")