Re-Post - Incrementing Numbering

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

Guest

Can anyone assist me with this.
Thanks, IEJ
Thank for responding. Are you able to tell me how to get
them to increment after you determine the highest
number. Say the number I want to start with is 762 and I
have 5 999's in the Route field and the Sequence should
be 762, 763, etc. how do I get that field to populate.

Thanks,
IEJ
 
Hi,



SELECT MIN(a.id)+1
FROM myTable As a LEFT JOIN myTable As b
ON (a.ID+1) = b.ID
WHERE b.Id Is Null


Hoping it may help,
Vanderghast, Access MVP
 
Back
Top