aggregate functions

  • Thread starter Thread starter Sayanta
  • Start date Start date
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 ?
 
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]
 
Back
Top