Access 2002

  • Thread starter Thread starter Bob
  • Start date Start date
B

Bob

I have one table that is updated by adding a new record
each week. The must current record carries the balance.
The records are grouped bt accoount, I need only the last
record of each group for a report. I cannot get (LAST)
working. any help will be appreciated. Bob Thomas
(e-mail address removed)
 
Dear Bob:

LAST will not give you what you want. Use MAX() instead, applied to a
date/time column, to find only the most recent values (assuming there
are no future dates recorded).

Tom Ellison
Microsoft Access MVP
Ellison Enterprises - Your One Stop IT Experts
 
Back
Top