Data Type Mismatch in criteria expression

Giganews Newsgroups
Subject: Data Type Mismatch in criteria expression
Posted by:  accesspro (accessp…@gmail.com)
Date: Tue, 15 Dec 2015

If you have a moment, can you look at this snippet ?

Don't judge me, I inherited the table and field names.
I just can't see the problem.

    intAgentCount = DCount("agentid", "agent", "[agentid] = " & strAgentID)

TIA

Replies