Alright so it's been awhile since I've had a problem (thankfully) and I've been just chugging along happily for months.

However I am now working on creating a standard for hydraulic hose numbering - we've had no such standard previously, I've just given the hoses sequential numbers...I dealt with numbering groups by just bumping up different groups to a different number.  So, for example, on a vehicle we'll have hoses 001 thru 075 from one numbering group (say 3000 psi hose) and then for high pressure hose we'll have 101 thru 110, and for air hose we'll have 201 thru 225.

Our new standard, currently still in development, would like to use a numbering system such as: XX-YYY

Where:

XX = hose size in 16ths of an inch (i.e. 1 inch hose = 16-YYY)

YYY = sequential, non-repeating number. (to be eventually replaced by hose length if we get to a point where 3D hose routings aren't a huge pain in which case duplicates would be expected and acceptable since they would also be physically interchangeable).

The issue is:

Say I have a size 04, size 06, size 08, size 12 and size 16 hose in a given project.

The current formula ( LTY_FREQ + "-" + STRZ(VAL(WIR_NO),3,0 ) generates the following numbers for these hoses:

04-001

06-001

08-001

12-001

16-001

We would prefer:

04-001

06-002

08-003

12-004

16-005

Can this be achieved?

Bonus Question:  Can this be achieved across numbering groups, such that numbers assigned to group 1 would not be available to group 2, obviating the need for starting at 101, 201, etc. in other groups?