Module database 

Functions

daverage_fn

DAVERAGE(database, field, criteria) — average of field values for matching rows.

dcount_fn

DCOUNT(database, field, criteria) — count of numeric field values for matching rows.

dcounta_fn

DCOUNTA(database, field, criteria) — count of non-empty field values for matching rows.

dget_fn

DGET(database, field, criteria) — returns the single matching value, or error.

dmax_fn

DMAX(database, field, criteria) — max of field values for matching rows.

dmin_fn

DMIN(database, field, criteria) — min of field values for matching rows.

dproduct_fn

DPRODUCT(database, field, criteria) — product of field values for matching rows.

dstdev_fn

DSTDEV(database, field, criteria) — sample standard deviation of matching numeric values.

dstdevp_fn

DSTDEVP(database, field, criteria) — population standard deviation of matching numeric values.

dsum_fn

DSUM(database, field, criteria) — sum of field values for matching rows.

dvar_fn

DVAR(database, field, criteria) — sample variance of matching numeric values.

dvarp_fn

DVARP(database, field, criteria) — population variance of matching numeric values.

register_database