Hi,

My original data is in an MS Access db.
With Bullzip MS Access to MySQL i make a dump and i import this into a mysql db.

The db and all the tables have the same names.

In ms Access i made a crosstab query and the result is ok.
I copied this query into ARI Data Tables, but it seems not to work.

I post it here as example.
Are there functions not available?

TRANSFORM First(logbook_qsl.[APP_DXKeeper_QSO_NUMBER]) AS EersteVanAPP_DXKeeper_QSO_NUMBER
SELECT logbook_qsl.[APP_DXKeeper_DOK]
FROM logbook_qsl
WHERE (((logbook_qsl.[APP_DXKeeper_DOK])>"0"))
GROUP BY logbook_qsl.[APP_DXKeeper_DOK]
PIVOT logbook_qsl.[Band];

Thank You for the support...
Koen

Solved... TRANSFORM is not an sql statement...