sort 3 fields in MS Access 97
MS Access 97
How do I make a combo box sort 3 fields? They are all coming from the same table.
Software
MS Access 97
How do I make a combo box sort 3 fields? They are all coming from the same table.
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 akahl
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
by akahl
by akahl
This discussion is closed to new replies.
Sort by Trending