sorting recordsets

hello all ;P

this didnt work

Public Function SortGrid()

If cboSortOn.ListIndex = 0 Or cboSortOn.ListIndex = -1 Then
rsEquivalents.Sort = "Product Name"
Else
If cboSortOn.ListIndex = 1 Then
rsEquivalents.Sort = "Standard Pack Price Excl VAT"
End If
End If

End Function


it gave me this error

arguments are of the wrong type, are out of acceptable range, or are in conflict with one another

can anyone help me :) ?

thanx

Hi dan,

rsEquivalents.Sort = "Standard, Pack, Price, Excl, VAT"

Separate your values with commas.

twas one variable name so i put it in [Standard Pack Price Exl VAT]
and it worked.

thank you :)
did my game work for you?

how do i sort on currency, ie not alphabetically?

i would like

10
15
20
30
100
105

not

10
100
105
20
30

How are you sorting?

:)

Hmm... it works fine for me.

Does it work if the field is numeric?

the field is currency eg R1,00 R100,00 R2,00

it sorts it in that order... which is the wrong order :(

thanx :)