Order Number

[Simon]

I would like to geneter the order number in the following formate

WS0001

How would i code this so it adds 1 on each time a new recored

Thanks

 

[Simon]

Thanks

but i forgot to say i did not want to use auto numbers as the database
will go on mysql server

Thanks

Hi Simon

The simplest method would be to have an Autonumber field - set the format to
0000 and the add MS whenever you need to show, print it.
In a form ="MS"&[AutoNumber]
In a query Something:"MS"&[AutoNumber]

You can use the form or query to generate a report or just use the field for
user information

Hope this helps
--
Buon Natale, Happy Chritmas.

Wayne
Manchester, England.
Scusate,ma il mio Inglese fa schiffo
Percio se non ci siamo capiti, mi mandate un
messagio e provero di spiegarmi meglio.

I would like to geneter the order number in the following formate

WS0001

How would i code this so it adds 1 on each time a new recored

Thanks

 

[Jeff Boyce]

The downside to using AutoNumbers is that they may, at some point, skip
values. This tends to make the auditors fussy, even though there are
legitimate (i.e., non-nefarious) reasons why this happens (e.g., a new
record started, then cancelled will "eliminate" an Autonumber).

An alternate approach is to come up with a "roll your own" sequencing
routine -- check at mvps.org/access and search for Custom Autonumber for a
way to do this.

Regards

Jeff Boyce
Microsoft Office/Access MVP

Hi Simon

The simplest method would be to have an Autonumber field - set the format
to
0000 and the add MS whenever you need to show, print it.
In a form ="MS"&[AutoNumber]
In a query Something:"MS"&[AutoNumber]

You can use the form or query to generate a report or just use the field
for
user information

Hope this helps
--
Buon Natale, Happy Chritmas.

Wayne
Manchester, England.
Scusate,ma il mio Inglese fa schiffo
Percio se non ci siamo capiti, mi mandate un
messagio e provero di spiegarmi meglio.

I would like to geneter the order number in the following formate

WS0001

How would i code this so it adds 1 on each time a new recored

Thanks