Help with proper syntax on dcount with and

[MightyRoo]

Would really appreciate some help with this and reasoning.....

'THIS WORKS (below)
     blah = DCount("[value_id]", "mage_catalog_product_entity_va[URL unfurl="true"]http://www.tek-tips.com/threadminder.cfm?pid=702rchar",[/URL] "[attribute_id] = " & [XAttributeID])
'THIS WORKS
     blah1 = DCount("[value_id]", "mage_catalog_product_entity_varchar", "[entity_id] = " & [entity_id])
'How do I make this work
     blah2 = DCount("[value_id]", "mage_catalog_product_entity_varchar", "[attribute_id] = " & [XAttributeID] And "[entity_id] = " & [entity_id])

Access generates a "Type Mismatch" Error 13
I have tried this multiple ways and just get different errors.
Thanks!

 

[MajP]

[attribute_id] = " & [XAttributeID] & " And [entity_id] = " & [entity_id]

 

[MightyRoo]

Thanks!