Order By

[rfear]

Can a form be ordered by more than one field ?

I have a form whos 'Order By' field is set to 'NEW_tblUsers.ROLE', this works fine but only sorts one column of data.

Is there a way to cascade the sort order over more than one field ?

 

[RuralGuy]

I would control the sort order in the underlying query rather than using the Form's OrderBy property but YES you can have more than one column in your OrderBy clause/property. I believe you separate them with a semicolon ";" in the property and a comma in the query.

 

[boblarson]

I believe you separate them with a semicolon ";" in the property and a comma in the query.

No, it's a comma in both places and as a string:

Me.OrderBy = "FieldOneName, FieldTwoName DESC, FieldThreeName"
Me.OrderByOn = True

 

[rfear]

Thanks, works a treat