Sub form functions are only used on a parent form. They calculate values from a complete set of sub forms, not one individual sub form. All sub form functions want the unique name of the sub form item on this form (not the name of the sub form's form), and the unique name of an item on the sub form.
They all begin with "D" for "data".
They all begin with "D" for "data".
DCOUNT
|
Form
|
Where
|
Result
|
|---|---|---|
|
DCOUNT(g, h)
|
g is a sub form unique name
h is a unique name for an item on the sub form |
A number
|
Description
Counts the number of sub forms for g where h is not empty.
|
Example
|
|---|
|
=DCOUNT('Parts', 'Part reference')
|
DSUM
|
Form
|
Where
|
Result
|
|---|---|---|
|
DSUM(g, h)
|
g is a sub form unique name
h is a unique name for an item on the sub form |
A number
|
Description
Adds up all the h items on all the sub forms for g.
|
Example
|
|---|
|
=DSUM('Parts', 'Part cost')
|
DMAX
|
Form
|
Where
|
Result
|
|---|---|---|
|
DMAX(g, h)
|
g is a sub form unique name
h is a unique name for an item on the sub form |
A number
|
Description
Finds the highest value of all the h items on all the sub forms for g.
|
Example
|
|---|
|
=DMAX('Parts', 'width')
|
DMIN
|
Form
|
Where
|
Result
|
|---|---|---|
|
DMIN(g, h)
|
g is a sub form unique name
h is a unique name for an item on the sub form |
A number
|
Description
Finds the smallest value for all the h items on all the sub forms for g.
|
Example
|
|---|
|
=DMIN('Parts', 'Part cost')
|
DAVERAGE
|
Form
|
Where
|
Result
|
|---|---|---|
|
DAVERAGE(g, h)
|
g is a sub form unique name
h is a unique name for an item on the sub form |
A number
|
Description
Calculates the average value of all the h items on all the sub forms for g.
|
Example
|
|---|
|
=DAVERAGE('Parts', 'Part Cost')
|