Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.databases.ms-access > #737

Re: using OrderBy and string functions

Show all headers | View raw

"Bob Barrows" <reb01501@NOyahooSPAM.com> wrote

 >  So you're letting your users dictate your
 > database design? Recipe for disaster, that ...

I agree with your conclusion but understood that emanning named the 
Field/Column "Block" and the users chose the content.

It's really a matter of the users not understanding that alphanumeric sorts 
differently from numeric.

And, if the users choose the content, and he optimizes for "Block" followed 
by a numeric, there's nothing that would keep the users from choosing some 
other combination of alphabetic and numeric and not liking the way those 
sorted...  suppose a user entered "ABC010XYZ1" and another chose 
"ABC1XYZ02"... how would they expect that to be sorted? The absolute best 
solution is to give the users a short course on what they don't understand, 
and why they aren't seeing what they expect -- teach them the difference 
between alphanumeric sort order and numeric sort order.

If, and only if, the users can specific a logical and consistent order in 
which they want arbitrary alphanumeric values to sort (difficult, and 
probably impossible, to cover all possible cases) can you handle a "custom 
sort order".

 Larry Linson
 Microsoft Office Access MVP 

Back to comp.databases.ms-access | Previous | Next — Previous in thread | Find similar | Unroll thread

Thread

using OrderBy and string functions emanning <emanning@kumc.edu> - 2011-03-30 13:49 -0700
  Re: using OrderBy and string functions "Phil" <phil@stantonfamily.co.uk> - 2011-03-30 22:59 +0100
    Re: using OrderBy and string functions "Access Developer" <accdevel@gmail.com> - 2011-03-30 20:25 -0500
      Re: using OrderBy and string functions "Phil" <phil@stantonfamily.co.uk> - 2011-03-31 09:34 +0100
        Re: using OrderBy and string functions "Access Developer" <accdevel@gmail.com> - 2011-03-31 21:14 -0500
  Re: using OrderBy and string functions "Bob Barrows" <reb01501@NOSPAMyahoo.com> - 2011-03-31 07:29 -0400
    Re: using OrderBy and string functions emanning <emanning@kumc.edu> - 2011-03-31 06:28 -0700
      Re: using OrderBy and string functions imb <imb4u@onsmail.nl> - 2011-03-31 06:47 -0700
        Re: using OrderBy and string functions emanning <emanning@kumc.edu> - 2011-03-31 07:35 -0700
      Re: using OrderBy and string functions "Bob Barrows" <reb01501@NOyahooSPAM.com> - 2011-03-31 09:56 -0500
        Re: using OrderBy and string functions "Access Developer" <accdevel@gmail.com> - 2011-03-31 21:26 -0500

csiph-web