Getting the last record stored in a table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I've tried to create a query that identifies the last record entered into a
table. The field I'm using with this totals query is called projectID which
is defined with an autonumber format. Each time I run the query it returns
the record with ProjectID=93 but there are 108 records in the table, so
shouldn't the query return a value of ProjectID=108? I can't figure out why
this is happening. Does anyone have any suggestions?
 
Autonumbers don't have to be sequential and it's possible, but rare, that
they could even be negative numbers. Depending on an autonumber might be
causing you some grief.

Are you using Last in the Total row under ProjectID? If so try Max instead.
Last and First aren't much use unless you also sort by ProjectID.
 
Back
Top