Dcount help

[Montez659]

Sure this is a simple one, but I can't see it. I am getting a type mismatch on this:

 = DCount("[visitRepsID]", "JUNCtblSiteVisits_Reps", "[visitID] =" & [Forms]![Copy of SiteVisitDetails]![visitID] And "[repRole] = 'Primary'")

where this part works:

 = DCount("[visitRepsID]", "JUNCtblSiteVisits_Reps", "[visitID] =" & [Forms]![Copy of SiteVisitDetails]![visitID])

Seems as if it doesn't like my "And" in there, but I can't figure out how to do it. visitRepsID and visitID are both numbers and repRole is string from table JUNCtblSiteVisits_Reps. I am basically wanting to count the records in the junction table for this particular record (visitID) labeled as primary.

Thanks in advance!

 

[boblarson]

You have a misplaced quote and no ampersand or space where there should be one.

What you have:

= DCount("[visitRepsID]", "JUNCtblSiteVisits_Reps", "[visitID] =" & [Forms]![Copy of SiteVisitDetails]![visitID] And "[repRole] = 'Primary'")

What it should be:

= DCount("[visitRepsID]", "JUNCtblSiteVisits_Reps", "[visitID] =" & [Forms]![Copy of SiteVisitDetails]![visitID] & " And [repRole] = 'Primary'")

 

[Montez659]

Ahh, thanks a bunch Bob! Didn't have any of my books with me and couldn't find a good example through Google. Works great!