Sort Order and Case - AWB before AaB !

[chriswatson]

Is there any way to make the Sort Sequence in Reports to be Case Insensitive ?

Current Sequence ABA, ACA, AaA (Upper case has priority)

Preferred Sequence AaA, ABA, ACA (Case Insensitive)

 

[MichaelRed]

option compare binary ????
MichaelRed
m.red@att.net

There is never time to do it right but there is always time to do it over

 

[CosmoKramer]

From Access help:

If you use Option Compare Text in the Declarations section of a module, string comparisons aren't case-sensitive. If you use Option Compare Binary, comparisons are case-sensitive.

 

[MichaelRed]

once again i feel the cart-horse arrangement has n=me confused.

MichaelRed
m.red@att.net

There is never time to do it right but there is always time to do it over