Sorting 1

[Lourry]

Hello all,

When I sort with the following code on a continuous form, it sorts...but it sorts the Upper case and Lower case separately. Is there a way to sort together?

If Me.OrderBy = "field" Then
    Me.OrderBy = "field DESC"
Else
    Me.OrderBy = "field"
End If
Me.OrderByOn = True

Thanks in advance!
-Lory

 

[BobJacksonNCI]

Hello Lory,

There are folks here who can provide an "I've done this" answer that can be guaranteed.

But, while you're waiting for that, you can try this:

If Me.OrderBy = "field" Then
    Me.OrderBy = "Lcase(field) DESC"
Else
    Me.OrderBy = "Lcase(field)"
End If
Me.OrderByOn = True

HTH,
Bob

 

[PHV]

Take a look at the Option Compare instruction.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[BobJacksonNCI]

PHV,

TOO COOL!

How do you REMEMBER all of the commands?
Bob