I currently am builing a access ordering system. I was going to use
autonumber as the order number but have heard that it is not recomended
to do this.
I have read that i need some code that will add +1 to the previou order
number.


Could any one tell me how to code this and the best way to do it so
that i do not duplicate any order numbers

Thanks

Simon

Simon wrote:
> I currently am builing a access ordering system. I was going to use
> autonumber as the order number but have heard that it is not
> recomended to do this.
> I have read that i need some code that will add +1 to the previou
> order number.
>
>
> Could any one tell me how to code this and the best way to do it so
> that i do not duplicate any order numbers
>
> Thanks
>
> Simon

See:

http://www.lebans.com/rownumber.htm

--
Joseph Meehan

Dia 's Muire duit

On my website (www.rogersaccesslibrary.com), is a small Access database
sample called "AutonumberProblem.mdb" which illustrates how to do this.

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/...UBED1=ACCESS-L


"Simon" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> I currently am builing a access ordering system. I was going to use
> autonumber as the order number but have heard that it is not recomended
> to do this.
> I have read that i need some code that will add +1 to the previou order
> number.
>
>
> Could any one tell me how to code this and the best way to do it so
> that i do not duplicate any order numbers
>
> Thanks
>
> Simon
>