Max() vs DMax()

mredmond

Registered User.
Local time
Today, 16:36
Joined
Oct 1, 2003
Messages
32
I am not quite clear on the difference between Max() and DMax(). Any clarity would be appreciated.

Also, all the examples show Max() and DMax() being run against tables? Can you apply them to a recordset in VBA? What would be the proper syntax? It is not working for me, so either it cannot be done, or I am doing it wrong.

Thanks.
 
Hello:
Max() Specifies the maximum number of records that will be returned by:
1) A query that returns data from an ODBC database to an Microsoft Access database (.mdb).
2)A view that returns data from a SQL database to an Access project (.adp).
'
The DMax function returns the maximum value that satisfies a certain specified criteria as opposed to no criteria for the Max() function.
Regards
Mark
 

Users who are viewing this thread

Back
Top Bottom