Sorting a combined column by one field.

[J355Y1]

Hi,
I have a subform which has a column called Event which is made up of 4 other columns called EStroke, Egroup, EDistance and Esex.
I have combined the columns using this code in the control source =[EStroke] & " " & [EGroup] & " " & [EDistance] & " " & [ESex]
I do not use any of the original columns only the new combined column called Event in my subform.

What i was wondering is how would i sort this combined column by EStroke?

Thanks!

 

[John Big Booty]

I suspect that you will need to sort the data by EStroke before you concatenate it.

 

[J355Y1]

How would i sort it before i combine it then keep it sorted?

 

[vbaInet]

You can still concatenate it, just add the EStroke field to a column to the query, untick the Show box, and set the Sort.

 

[J355Y1]

Thanks guys i managed to get it to work by sorting it first.

 

[vbaInet]

NB: If you don't have a grouping and any other sort in place, the position of that field is negligible. It can be the first, middle or last, if you only want to sort by that field.