Integer Data Type

[dvgef2]

Good Day to Everyone!

I have a very dumb question and I have been avoiding it because it sounds dumb. However, I really don't know the answer and I have researched it but I can't find the answer directly. I have read different things about the integer data type and I am somewhat confused about it. I have a database that keeps track of work orders, the work order number is an integer data type that starts at 1 and we are currently at Work Order# 60. How many work orders can be generated with this data type? I thought it would be 32, 700+ but I read something somewhere that leads me to believe that it may only be 255. I don't like not giving enough information but I think the only relevant thing you would need to know is that when a new work order gets generated, it receives the next higher number in sequence....Any help is always appreciated, thanks!

Dave

[pbaldy]

You are correct, it would be 32,767. 64k if you use the negative numbers.

[dvgef2]

Thanks Paul, I was hoping that you would say that!

I am not sure what this story meant when they talked about the '255' limitation with the integer data type because I am just not smart enough. I started thinking that maybe you can use any number between (+/-) 32,767 but only 255 times. I used integer data type a lot because I have been told my data bases use too many resources. Again, I don't even know what that means but I tried to use less resources on this one.

Thanks again. I really appreciate your comments, you have been extremely helpful to me during my Access woes! Have a good day!

Dave

[pbaldy]

Happy to help Dave!