MS Access: DCount Function
The Microsoft Access DCount function returns the number of records in a specified set of records (or domain).
DCount Function (Syntax)
The syntax for the DCount function is:
DCount ( expression, domain, [criteria] )
expression is the field that you use to count the number of records.
domain is the set of records. This can be a table or a query name.
criteria is optional. It is the WHERE clause to apply to the domain.
The DCount function can be used in the following versions of Microsoft Access:
- Access 2013, Access 2010, Access 2007, Access 2003, Access XP, Access 2000
Let's look at a simple example:
DCount("UnitPrice", "Order Details", "OrderID = 10248")
In this example, you would return the number of records in the Order Details table where the OrderID is 10248. This is the same as the following SQL statement:
SELECT Count([Order Details].UnitPrice) AS CountOfUnitPrice FROM [Order Details] WHERE ((([Order Details].OrderID)=10248));
DCount Examples (in VBA Code)
The DCount function can be used in VBA code in Microsoft Access. For example:
Dim LTotal As Long LTotal = DCount("UnitPrice", "Order Details", "OrderID = 10248")
In this example, the variable called LTotal would now contain the number of records in the Order Details table where the OrderID is 10248.
DCount Examples (in SQL/Queries)
You can also use the DCount function in a query in Microsoft Access.