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)

Do you have a question?

Our team is happy to advise you personally.

╳

Event ID* Order ID* First Name* Last Name* Email* Subject*

If you have a support question, please add your event ID!

Message*

Cookie	LastUser
Description	Stores the customer number from the last login through this browser. Used to prefill the user input in the login area.

Cookie	Cookieconsent
Description	Used to check if the cookie banner was shown to you in the last 35 days. Also stores your specific cookie banner selections.

Cookie	contactform_flag
Description	Checks if the red box with the contact form hint has already been presented in this browser session.checks if the red box with the contactform hint has already been presented in this browser session

Cookie	PHPSESSID
Description	This key is necessary to anonymously identify the current user session by our system. Essential for shopping cart, order process, customer account, etc.This key is necessary to anonoumously identify the current user session by our system. Essential for shopping cart, order process, customer account etc.

Cookie	Vimeo
Description	We use the video platform Vimeo to host videos and embed them into our website. When clicking on the video, Vimeo may set cookies in the browser.

Cookie	analytics_storage
Description	Checks if Google Analytics cookies can be stored to analyze user behavior on the website and understand how visitors interact with our content. By consenting, you help us improve the user experience.

Cookie	ad_storage
Description	Checks if advertising cookies can be stored, which are used for personalized advertising and retargeting.

Cookie	ad_personalization
Description	Controls whether ads are personalized based on the user's behavior and interests to show tailored ads.

Cookie	ad_user_data
Description	Controls whether the user's personal data can be processed for advertising purposes, such as information about age, gender, or interests.

Contact us!