dcount problem

[pat67]

Ok, i am at a loss. i am doing a dcount that was working and now it
isn't. the only thing i can think of is that now not all of the
criteria are available.

=DCount("[Score]","[Scores]","[Player1]=[Name]")

not all of the "Player1" field are in the report using "Name"

should that be happening?

 

[pat67]

Ok, i am at a loss. i am doing a dcount that was working and now it
isn't. the only thing i can think of is that now not all of the
criteria are available.

=DCount("[Score]","[Scores]","[Player1]=[Name]")

not all of the "Player1" field are in the report using "Name"

should that be happening?

never mind. I am an idiot. I can't use the word Name. I changed it and
now it is fine. Thanks anyway