MAX() operator with auto number field

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

Guest

The following query returns the wrong answer:
SELECT Max(job.job_id) AS MaxOfjob_id FROM job;
In this case, job_id is an auto number field of the job table, and its
primary key. I built the query interactively using the Query grid.

The problem is that there are 10 records in the job table (no deletions), so
the maximum job_id should be 10. It is consistently 9.

Why?

How can I get the correct answer (interactively, or using VBA)?

Thanks for your help
 
Back
Top