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.
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.