View Single Post
  #9  
Old September 24th, 2007, 11:15 PM posted to microsoft.public.access.reports
Tom
external usenet poster
 
Posts: 72
Default Attn: Marshall Barton

Chuck,

Here that file with everything sorted.

Thanks

Part Num,L,M,R
1.1,#a,#,s
1.11,#a,##,s
1.111,#a,###,s
1.1111,#a,####,s
1.11111,#a,#####,s
11.1,##a,#,s
11.11,##a,##,s
11.111,##a,###,s
11.1111,##a,####,s
11.11111,##a,#####,s
111.1,###a,#,s
111.11,###a,##,s
111.111,###a,###,s
111.1111,###a,####,s
111.11111,###a,#####,s
1-1,#a,#,s
1-11,#a,##,s
1-111,#a,###,s
1-1111,#a,####,s
1-1111A,#a,####,a
1-1111AA,#a,####,aa
11-11A12,##a,##,a##
11-111A12,##a,###,a##
111-1,###a,#,s
111-11,###a,##,s
111-111,###a,###,s
111-1111,###a,####,s
111-1111A,###a,####,a
111-1111AA,###a,####,aa
111-1111AAA,###a,####,aaa
111-11111,###a,#####,s
111-11111A,###a,#####,a
111-11111AA,###a,#####,aa
111-11111AAA,###a,#####,aaa
111-D1,###a,a#,s
111-D11,###a,a##,s
111-D111,###a,a###,s
111-D1111,###a,a####,s
11A1,##a,#,s
11A11,##a,##,s
11A11A,##a,##,a
11A11AA,##a,##,aa
11A111,##a,###,s
11A111A,##a,###,a
11A111AA,##a,###,aa
11A1111,##a,####,s
11A1111A,##a,####,a
11A1111AA,##a,####,aa
15-1,##a,#,s
15-11,##a,##,s
15-11A,##a,##,a
15-111,##a,###,s
15-111A,##a,###,a
15-1111,##a,####,s
15-1111A,##a,####,a
15-1111AA,##a,####,aa
15-11111,##a,#####,s
15-11111A,##a,#####,a
15-111111,##a,######,s
15-111111A,##a,######,a
1PG,s,#,aa
11,s,##,s
11N,s,##,a
11PG,s,##,aa
33APG,s,##,aaa
111,s,###,s
111APG,s,###,aaa
111N,s,###,a
111PG,s,###,aa
1111,s,####,s
1111APG,s,####,aaa
1111PL,s,####,aa
1111PLA,s,####,aaa
1111R,s,####,a
11111,s,#####,s
11111PL,s,#####,aa
11111PLA,s,#####,aaa
11111R,s,#####,a
111111,s,######,s
1111111,s,#######,s
1111111A,s,#######,a
111111PL,s,#######,aa
111111PLA,s,#######,aaa
111111R,s,#######,a
11111111,s,########,s
761-1,aaaa,#,s
761-11,aaaa,##,s
761-111,aaaa,###,s
761-1111,aaaa,####,s
761-1111A,aaaa,####,a
761-1111AA,aaaa,####,aa
761-11111,aaaa,#####,s
761-1111111,aaaa,#######,s
B-111,aa,###,s
B-1111,aa,####,s
BAL-111,aaaa,###,s
BD1,aa,#,s
BD1M,aa,#,a
BD11,aa,##,s
BD11BM,aa,##,aa
BD11M,aa,##,a
BD11ABC,aa,##,aaa
BD111,aa,###,s
BD111BM,aa,###,aa
BD111M,aa,###,a
BD1111,aa,####,s
BD1111AM,aa,####,aa
BD1111C,aa,####,a
H11,a,##,s
H11A,a,##,a
H111,a,###,s
H111-2,a,###,a#
H111A,a,###,a
H111AC,a,###,aa
H1111,a,####,s
H1111-2,a,####,a#
H1111A,a,####,a
H1111AC,a,####,aa
H11111,a,#####,s
H11111-2,a,#####,a#
H11111A,a,#####,a
H11111AA,a,#####,aa
H111111,a,######,s
H111111A,a,######,a
H111111R,a,######,a
HP-11111.1,aaa,#####,a#
MC11111,aa,#####,s
MC111111,aa,######,s
MC111111A,aa,######,a
PGD1,aaa,#,s
PGD1M,aaa,#,a
PGD11,aaa,##,s
PGD11BM,aaa,##,aa
PGD11BMA,aaa,##,aaa
PGD11M,aaa,##,a
PGD111,aaa,###,s
PGD111BM,aaa,###,aa
PGD111BMA,aaa,###,aaa
PGD111M,aaa,###,a
PGD1111,aaa,####,s
PGD1111AM,aaa,####,aa
PGD1111AMA,aaa,####,aaa
PGD1111C,aaa,####,a
PGD11111,aaa,#####,s
PGD111111,aaa,######,s
RC1111QS,aa,####,aa
RC11111A,aa,#####,a
RC11111ANS,aa,#####,aaa
RC11111NS,aa,#####,aa
SNA6A24D,aaa,#,a##a
SNA6A2D,aaa,#,a#a
SSRD2,aaaa,#,s
SSRD52,aaaa,##,s
SSRD52M,aaaa,##,a
SSRD552,aaaa,###,s
SSRD552M,aaaa,###,a
SSRD5521,aaaa,####,s
SSRD5521M,aaaa,####,a
T1PG,a,#,aa
T11PG,a,##,aa
T33APG,a,##,aaa
T111APG,a,###,aaa
T111PG,a,###,aa
T1111APG,a,####,aaa
T11111APG,a,#####,aaa
T11111PG,a,#####,aa
TSSRD20,aaaaa,##,s
TSSRD20A,aaaaa,##,a
TSSRD200,aaaaa,###,s
TSSRD200A,aaaaa,###,a
,,,
whe,,,
,# is any digit,,
,a is any nondigit,,
,s is just spaces (i.e empty),,


On Sun, 23 Sep 2007 17:39:49 -0400, Chuck wrote:

On Sun, 23 Sep 2007 16:37:25 -0400, Tom wrote:

Chuck,

No, the part numbers are not interchangeable.

Yes, they are from other organizations as well as my own.

Not sure what you mean by unbreakable UDF.

Thanks

Big snip
Would you please re-post your list of Part Num(s) sorted exactly the way you
want them. Possibly with the *answer* to your question, a set of equations can
be devised that will produce that *answer*.

Chuck

--
Tom