DCount syntax for multiple criteria with a checkbox (1 Viewer)

[Lkwdmntr]

Hi guys, I'm a little rusty on the syntax for multiple criteria.

I need the number of records that have the Plan ID of "Me.txtWeeklyPlanID" with the ActionIncluded = True and the ActionIDFK = 3

This is the code I use, but I get an "Expected list separator" error.

DCount("[ActionIDFK]", "tblActionsPerWeeklyPlan", "[WeeklyPlanIDFK] = " & Me.txtWeeklyPlanI & " AND [ActionIncluded] = True AND ActionIDFK = 3)

Any help would be appreciated.

 

[ebs17]

... & " AND [ActionIncluded] = True AND ActionIDFK = 3")

 

[Lkwdmntr]

... & " AND [ActionIncluded] = True AND ActionIDFK = 3")

DCount("[ActionIDFK]", "tblActionsPerWeeklyPlan", "[WeeklyPlanIDFK] = " & Me.txtWeeklyPlanID & " AND [ActionIncluded] = True AND [ActionIDFK] = 3")

Now I'm getting an = sign is expected

 

[Lkwdmntr]

Nevermind, I was using the "Immediate Window" without using the ?

 

[Lkwdmntr]

I

... & " AND [ActionIncluded] = True AND ActionIDFK = 3")

Thanks a bunch!