aggregate functions

S

Sayanta

Hi,
I am using Access 2000, and was wondering if there is any way to include
aggregate functions (like Dlast() etc) without of using the "Totals" field ?
 
J

John Vinson

Hi,
I am using Access 2000, and was wondering if there is any way to include
aggregate functions (like Dlast() etc) without of using the "Totals" field ?
Click to expand...

You can certainly use them as calculated fields in a query, or as
criteria, or as Control Source properties for form or report
textboxes, yes.

What specifically would you like to do with them?

Do note that the DLast() and DFirst() functions are pretty nearly
useless: they return the last and first records *in disk storage
order*, an order over which you have no control.

John W. Vinson[MVP]
 
Top