A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Setting Up & Running Reports
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Attn: Marshall Barton



 
 
Thread Tools Display Modes
  #1  
Old September 20th, 2007, 02:18 PM posted to microsoft.public.access.reports
Tom
external usenet poster
 
Posts: 72
Default Attn: Marshall Barton

Marsh,

In case you missed my reply, I posted the sort table on 9/15/2007 to your
attention.

Thx for your help.

Tom
--
Tom

  #2  
Old September 20th, 2007, 05:36 PM posted to microsoft.public.access.reports
Marshall Barton
external usenet poster
 
Posts: 5,361
Default Attn: Marshall Barton

Tom wrote:
In case you missed my reply, I posted the sort table on 9/15/2007 to your
attention.



I didn't miss it, but I am still analyzing it to try to find
a consistent set of parsing rules. Sorry, I should have
posted a reply to that effect so you would know I was
working on it when I get a little spare time.

--
Marsh
MVP [MS Access]
  #3  
Old September 20th, 2007, 09:35 PM posted to microsoft.public.access.reports
Tom
external usenet poster
 
Posts: 72
Default Attn: Marshall Barton

Marsh,

No problem...thanks for the update!.

Tom


On Thu, 20 Sep 2007 11:36:49 -0500, Marshall Barton
wrote:

Tom wrote:
In case you missed my reply, I posted the sort table on 9/15/2007 to your
attention.



I didn't miss it, but I am still analyzing it to try to find
a consistent set of parsing rules. Sorry, I should have
posted a reply to that effect so you would know I was
working on it when I get a little spare time.

--
Tom

  #4  
Old September 21st, 2007, 11:06 AM posted to microsoft.public.access.reports
Chuck
external usenet poster
 
Posts: 261
Default Attn: Marshall Barton

On Thu, 20 Sep 2007 09:18:03 -0400, Tom wrote:

Marsh,

In case you missed my reply, I posted the sort table on 9/15/2007 to your
attention.

Thx for your help.

Tom


Is the sort table you posted, sorted the way you want after a sort?

Chuck

  #5  
Old September 21st, 2007, 11:54 PM posted to microsoft.public.access.reports
Tom
external usenet poster
 
Posts: 72
Default Attn: Marshall Barton

No, it was not in the correct order. It was in groups or patterns of
numbers.


On Fri, 21 Sep 2007 06:06:52 -0400, Chuck wrote:

On Thu, 20 Sep 2007 09:18:03 -0400, Tom wrote:

Marsh,

In case you missed my reply, I posted the sort table on 9/15/2007 to your
attention.

Thx for your help.

Tom


Is the sort table you posted, sorted the way you want after a sort?

Chuck

--
Tom

  #6  
Old September 22nd, 2007, 01:28 PM posted to microsoft.public.access.reports
Chuck
external usenet poster
 
Posts: 261
Default Attn: Marshall Barton

On Fri, 21 Sep 2007 18:54:00 -0400, Tom wrote:

No, it was not in the correct order. It was in groups or patterns of
numbers.


On Fri, 21 Sep 2007 06:06:52 -0400, Chuck wrote:

On Thu, 20 Sep 2007 09:18:03 -0400, Tom wrote:

Marsh,

In case you missed my reply, I posted the sort table on 9/15/2007 to your
attention.

Thx for your help.

Tom


Is the sort table you posted, sorted the way you want after a sort?

Chuck


Are some of the wildly different part numbers, interchangeable parts?
If yes, there is no way to sort them in any useful manner with the data you
have shown us show.

Are the part numbers from different organizations?
If yes, there is no way to sort them in any useful manner with the data you
have shown us show.

In your post of 7/2/2007, you said you had an unbreakable UDF. Is it still
unbreakable?
If no, why not?

Chuck
  #7  
Old September 23rd, 2007, 09:37 PM posted to microsoft.public.access.reports
Tom
external usenet poster
 
Posts: 72
Default Attn: Marshall Barton

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

On Sat, 22 Sep 2007 08:28:25 -0400, Chuck wrote:

On Fri, 21 Sep 2007 18:54:00 -0400, Tom wrote:

No, it was not in the correct order. It was in groups or patterns of
numbers.


On Fri, 21 Sep 2007 06:06:52 -0400, Chuck wrote:

On Thu, 20 Sep 2007 09:18:03 -0400, Tom wrote:

Marsh,

In case you missed my reply, I posted the sort table on 9/15/2007 to your
attention.

Thx for your help.

Tom

Is the sort table you posted, sorted the way you want after a sort?

Chuck


Are some of the wildly different part numbers, interchangeable parts?
If yes, there is no way to sort them in any useful manner with the data you
have shown us show.

Are the part numbers from different organizations?
If yes, there is no way to sort them in any useful manner with the data you
have shown us show.

In your post of 7/2/2007, you said you had an unbreakable UDF. Is it still
unbreakable?
If no, why not?

Chuck

--
Tom

  #8  
Old September 23rd, 2007, 10:39 PM posted to microsoft.public.access.reports
Chuck
external usenet poster
 
Posts: 261
Default Attn: Marshall Barton

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
--
  #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

  #10  
Old September 25th, 2007, 01:25 PM posted to microsoft.public.access.reports
Chuck
external usenet poster
 
Posts: 261
Default Attn: Marshall Barton

On Mon, 24 Sep 2007 18:15:41 -0400, Tom wrote:

Chuck,

Here that file with everything sorted.

Thanks

Big Snip

OK, I'll play with it and let you know if I have any luck.

Chuck
--
 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 01:36 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.