Can someone help me with getting this to work.....

Am trying to Count the check boxes that are TRUE AND between date range.

=DCount("[Bac_T_Fish]","Specimen Query","[Bac_T_Fish] =-1" & [date] Between #1/1/2006# And #1/31/2006#)

Try

"[Bac_T_Fish] =-1 AND #" & [date] "# Between #1/1/2006# And #1/31/2006#")

However, date is a reserved word, and will probably cause you problems here.

I renamed the [date] to avoid problem - however I get Syntax Error no matter what i do

Sorry - bit of a typo in there

"[Bac_T_Fish] =-1 AND #" & [date] & "# Between #1/1/2006# And #1/31/2006#"