"KenSheridan via AccessMonster.com" u51882@uwe wrote in message
news:a25b114e44fa5@uwe...

Arvin's solution, while seeding the start number, has the disadvantage, as
Keith has pointed out, of not guaranteeing an unbroken sequence (or a
sequence at all for that matter), for which an autonumber should never be
used, an autonumber being intended to ensure arbitrary unique values and
nothing else



Thanks for confirming that Ken, I thought I was going a bit doo-lally on
that one for a while

Keith.