[Firebird-odbc-devel] Problem group by in front-end (odbc)

[<ola...@sa...>]

Hello,

I've a problem. In Firebird 1.5 the follow sql-statement works fine:

SELECT TPROJEKTE.KOMMISIONSNR
FROM TPROJEKTE
WHERE (((TPROJEKTE.KUNDE)=[forms]![FAuftragNeu].[skunde]))
GROUP BY TPROJEKTE.KOMMISIONSNR
ORDER BY TPROJEKTE.KOMMISIONSNR DESC;

Without the order by statement the data sorted by tprojekte.kommisionsnr ascending. But I need the data sorted descending.
...order by 1 does not work too.

The Database-Server is now Firebird 2.1. The front-end is microsoft access over odbc (firebird-odbc-driver)

Can I change the sql-statement that it works again?

thank you very much.

Regards

Olaf