Autonumber Increment

[dinellest via AccessMonster.com]

HI

OK, ALMOST DONE.

WHAT I NEED IS A NUMBER THAT STARTS WITH 40 (OUR REGION) AND INSERTS 4
SEQUENTIAL NUMBERS.

THIS CALL RECORD INCREMENTS BY 1 AND SHOULD LOOK SOMETHING LIKE 400001 THEN
400002, 400003, 400004….

THIS NUMBER THEN POPULATES A FIELD CALLED CALL_NUMBER.

AS ALWAYS THANKS

STEPHEN

 

[Tom van Stiphout]

On Mon, 06 Oct 2008 13:27:26 GMT, "dinellest via AccessMonster.com"

This is a FAQ - you should have no problems finding solutions at
groups.google.com. Keywords: autonumber, dmax.

If you have a fixed prefix you don't have to store it in the db:
select "40" & Format$(MySequentialNo,"0000") as CallNumber from
MyTable

-Tom.
Microsoft Access MVP