Discussion Locked

sort 3 fields in MS Access 97

0 helpful
5 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

MS Access 97

How do I make a combo box sort 3 fields? They are all coming from the same table.

5 replies

by arwin

I don't know exactly what you're trying but you could try the following:

Build a query where you put the following expression in the first column of your design grid:
Field1 & Field2 & Field3

You can change any fieldname in order to get the right sorting you look for. The only thing is that they have to by string types.

by glen_mcleod

Do you want the combo box to sort the data or do you want the data sorted by the time it gets to the combo box?

If the latter, then just specify the sort order in your source query:

Select [ColumnNames]
From TableName
Where [Condition(s)]
Order By Column1, Column2 , Column3

Glen

This discussion is closed to new replies.