I'm putting togheter a e-store and want Acess to generate the order numbers. The simple increment is bad because it only generates numbers like 1,2,3 ect. Then I tried the ramdom number thing and the numbers that come out now are like : 5700399, 10033334,
-5710399, -10033334. I just don't want negative numbers to come out. Anyone knows how to format those generated numbers?