It is for inventory tracking of parking passes so unfortunately all the numbers matter, each has a unique number which may or may not have leading zeros and may be 6 or 7 digits in length currently and possibly get longer as time goes on,normally wouldn't be an issue because they normally have a two or three digit alpha prefix, but since we want to calculate the number sold based on (last pass # minus first pass # + 1= total passes sold) we have...

There are two identical fields I have the issue with one is first pass used and can any combination of up to 7 numbers. The second is last pass number which is the same way. Both fields could have as many as six leading zeros or as few as no leading zeros the numbers are either 6 or seven digits long depending on the type of pass or whether we grow into more digits as the numbers become used. The two fields will be calculated as (last pass number...

The difficulty I am having is that no matter what I do I can only make it have an exact number of digits when I need it to be able to vary because the numbers have to be exact if I make it eight digits long then it adds additional zeros to the six digit numbers and so on how can I get it to allow variable lengths of numbers and variable numbers of leading zeros example pass numbers could be 001214 or 000503 or 0925645 depending on the pass type and...

I have 2 fields where I track pass numbers which need to be calculated fields. These numbers are 6 to 8 digits long and have varying number of leading 0's (very novice level) at access how can I format these fields to accept these 0s and show them