Max Function vs Last Function

[Guest]

I am trying to always retrieve the last date entered in a query. I have
tried the 'last' function but it did not give me the latest record date. I
am currently using the 'Max' function and it appears to be working but I am
leary using this function with date.
The data looks like this.
Person Points Point Date
AAAA 1 4/2/07
AAAA .5 05/05/07
AAAA .5 09/01/07

I am summing on the points and grouping on person. The results I want is this

AAAA 2.0 09/01/07

Am I okay in using Max on the point date field?

 

[Pieter Wijnen]

yes, that's what it's there for

Pieter

 

[Guest]

Thanks a bunch! I have been burned before and just wanted to be safe.

 

[John W. Vinson]

I am trying to always retrieve the last date entered in a query. I have
tried the 'last' function but it did not give me the latest record date.

Last() is just about totally useless. It returns the last record *in disk
storage order* - and you can't control or predict that order. Max is the way
to go.

John W. Vinson [MVP]

 

[Bob Quintal]

Last() is just about totally useless. It returns the last record
*in disk storage order* - and you can't control or predict that
order. Max is the way to go.

John W. Vinson [MVP]

I disagree, in that last on a query that specifies the order works
perfectly well. The same caveat applies to first.