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.

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