General discussion

Locked

sort 3 fields in MS Access 97

By akahl ·
MS Access 97

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

This conversation is currently closed to new comments.

5 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

sort 3 fields in MS Access 97

by Arwin In reply to sort 3 fields in MS Acces ...

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.

Collapse -

sort 3 fields in MS Access 97

by akahl In reply to sort 3 fields in MS Acces ...

The question was auto-closed by TechRepublic

Collapse -

sort 3 fields in MS Access 97

by Glen_McLeod In reply to sort 3 fields in MS Acces ...

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

Collapse -

sort 3 fields in MS Access 97

by akahl In reply to sort 3 fields in MS Acces ...

The question was auto-closed by TechRepublic

Collapse -

sort 3 fields in MS Access 97

by akahl In reply to sort 3 fields in MS Acces ...

This question was auto closed due to inactivity

Back to Software Forum
5 total posts (Page 1 of 1)  

Related Discussions

Related Forums