DCount()

DCount counts the number of participants fulfilling a filter (first parameter):

DCount("[Finished]") - returns the number of finishers
DCount("T101>0 AND [Contest]=1") - returns the number of participants registered in Contest 1, who have a result in Result 101

If your filter contains text values, you need to escape the quotes with more quotes. Examples:

DCount("[Gender]=""f""") - Returns the number of female participants
DCount("[Gender]="""  & [Gender] & """") - Returns the number of participants who are of the same gender as the considered participant.

Note that the aggregation functions are not very fast and should be used rarely.

DCount(;true)

DCount(;true) counts both the number of participants in an eventfile AND participants that are in the process of a registration currently, fulfilling a fiter

DCount("[Gender]="""  & [Gender] & """";true)

Returns the number of participants already registered and those who are in the process of the registration who are of the same gender as the considered participant. 

Example:

  • 5 female participants already existing in the eventfile
  • 4 female participants not yet registered, but in the process of registering
  • ==> 9 participants in total.