Max vs. Last

B

Bibi

It's been awhile since I've worked with one particluar database of mine and I
have forgotten the distinction betwen last and max - could some one help?
 
D

Duane Hookom

Last would assume a specific order to records with Access tables don't have
unless you apply a sort order. Max is max.
 
J

John Spencer (MVP)

Max = biggest value
Last = the last record retrieved. Can be the most recent record added, but not
necessarily. Thinks of First and Last as being the equivalent of getting a
random record in the group.
 
J

John Spencer (MVP)

Max = biggest value
Last = the last record retrieved. Can be the most recent record added, but not
necessarily. Thinks of First and Last as being the equivalent of getting a
random record in the group.
 
M

Michel Walsh

Hi,


Last has it uses, it is the "row"-aggregate Joe Celko described in some of
his books. All the fields aggregated under Last are guaranteed to come from
the "same" record.


Vanderghast, Access MVP
 
R

Rick Brandt

Steve Schapel said:
As I understand it, Rick, they are not arbitrary if you define a sort order.
Click to expand...

It's been a while, but in the testing I did a while back on this it seemed that
when using local Jet tables (recently compacted) that First and Last acted as
one would expect. When using linked tables across a network the results became
much less reliable and if using ODBC linked tables then all bets were off.
 
Top