You will find them in the VBA help file. You have to open a code window
(Alt+F11) then open help.
Here are a couple of short excerpts from the help file:
You can use the DCount function to determine the number of records that are
in a specified set of records (a domain). Use the DCount function in Visual
Basic, a macro, a query expression, or a calculated control.
For example, you could use the DCount function in a module to return the
number of records in an Orders table that correspond to orders placed on a
particular date.
DCount(expr, domain, [criteria])
You can use the DSum functions to calculate the sum of a set of values in a
specified set of records (a domain). Use the DSum function in Visual Basic,
a macro, a query expression, or a calculated control.
For example, you could use the DSum function in a calculated field
expression in a query to calculate the total sales made by a particular
employee over a period of time. Or you could use the DSum function in a
calculated control to display a running sum of sales for a particular
product.
DSum(expr, domain, [criteria])
These functions are refered to as "domain Aggregate Functions". The
remaining similar functions are:
DAvg
DLookup
DFirst, DLast
DMin, DMax
DStDev, DStDevP
DVar, DVarP
--
Wayne Morgan
MS Access MVP
"Richard Holliingsworth" <wi*********************@boeing.com> wrote in
message news:Hs********@news.boeing.com...
Hi folks.
Thanks for the help, but I can't seem to find either set of commands in
the Access 2K help file. Where should I look for these commands????
Thanks,
Richard H
Wayne Morgan wrote:
I believe that CountIf and SumIf are Excel functions. Check out DCount
andDSum, I believe they will do what you want.