I have a list box to select a list winners using a combo box. Everything works a it should so far. I want to add a count of the number of winners in the selected list using DCount. I can't get the criteria to work.
The first expression works and gives me the total count in the table, the second one is the one I want to count only the selected records but I get an #Error, ans I have not been able to resolve the issue.
Code:
=DCount("[Winner]","F1PoleT")
Code:
=DCount("[Winner]","F1PoleT","Winner=" & [WinnerCmb])
Thanks
Jim O