Order a query by a list, not ASC or DESC

HI

I'm making a query to an Access database, from Excel using this query "SELECT tblkmsDiarios.Matricula, SUM(tblkmsDiarios.Abastecimento) AS Total, tblMatriculas.UO FROM tblkmsDiarios INNER JOIN tblMatriculas ON tblkmsDiarios.Matricula = tblMatriculas.Matricula WHERE tblkmsDiarios.Matricula<>'OUTRA' GROUP BY tblkmsDiarios.Matricula, tblMatriculas.UO".

The results are what I want and are correct, what I wanted is for them to be ordered by the 'tblMatriculas.UO' field, but in accordance with the following order ('CON' , 'COGP' , 'COCN' , 'COCS' , ' COGL' , 'COS'), these are the values ​​that 'tblMatriculas.UO' can have.

Is it possible to do this by changing the query I have?

Thanks

Create a table with those values in one column and the sort order (1,2,3 etc) in a second column. Then link that table to the first table and you can order by the sort order column. You may also be able to use something like a CASE WHEN in the ORDER BY clause; I can't recall and it may depend on the provider you are using.

Edit: I strongly suspect CASE WHEN won't work, so it might have to be nested IIf functions.

Then you'll need nested IIf I think - e.g.

Please Login or Register  to view this content.