Access 2007 - not recognising dates under "last" in a query

  • Thread starter Thread starter Nigelweare
  • Start date Start date
N

Nigelweare

I have a query set up to identify the last date of attendance for
individuals. For some reason, it is not recognising any entries after
09/09/09 and before 04/10/09.
 
Last does not mean Latest. Use MAX to get the latest date, not LAST.

LAST refers to the last record seen, for the given group, at execution time,
which is not necessary the lastly appended record, in historical time.


Vanderghast, Access MVP
 
Back
Top