Dcount Check boxes

[elfranzen]

Text56.Value = DCount("[startplaying]", "tournamentlogtable", "[startplaying] = true" And "[endplaying]= false")

Ok Startplaying and Endplaying are check boxes I want to return a number of active people playing in the tournement what am I doing wrong here?

 

[RuralGuy]

Remove the quotes around And!

Text56.Value = DCount("[startplaying]", "tournamentlogtable", [b]"[startplaying] = true  And [endplaying]= false"[/b])

 

[elfranzen]

Thanks I had another error also but got them both fixed thanks for the help

 

[RuralGuy]

You're welcome. Glad to help.