Domain Aggregate Functions
Printer Friendly Page
Domain Aggregate Functions are like
SQL queries.
They are easy to use in Access.
The most useful
Domain Aggregate Functions are listed below:
| DAVG |
Average of the values in a set |
| DCOUNT |
Number of records in a set of records |
| DSUM |
Total of a set of records |
| DFIRST |
First record in a set |
| DLAST |
Last record in a set |
| DMIN |
Smallest value in a set |
| DMAX |
Largest value in a set |
Domain Aggregate syntax is:
DFunction(fieldname, table, [criteria] )
This is a standard
SQL statement.
It will return the
SUM of all amounts in the
Balance_Due field from the table
Invoices:
SELECT SUM(Balance_due) FROM Invoices
The equivalent
DSUM statement is:
DSUM("Balance_due", "Invoices")
Here is an example where the total Balances are placed in a textbox on a form.
TotalDue.text = DSUM("Balance_due", "Invoices")
This is an example of using the
WHERE clause of a SQL statement:
SELECT Sum(Balance_due) FROM Invoices WHERE [CustomerID] = '32413'
The equivalent
DSUM statement is:
DSUM("Balance_due", "Invoices", "[CustomerID] = '32413'")