L
lecoughlin
Hi all,
I am trying to count the number of records in my table matching a
certain criteria using the following code:
var = (DCount("*", "tblSites", "[state]=" & newProgramState))
newProgramState = Alabama, and there are 3 records in the table where
state = Alabama, however var is coming back = 0. Am I doing something
wrong?
Thanks in advance.
I am trying to count the number of records in my table matching a
certain criteria using the following code:
var = (DCount("*", "tblSites", "[state]=" & newProgramState))
newProgramState = Alabama, and there are 3 records in the table where
state = Alabama, however var is coming back = 0. Am I doing something
wrong?
Thanks in advance.