Cross tab queries, Unable to create them in ADP

[dwight1]

I use a lot of cross tabl queries in MDB. Now that we are upgrading to ADP can i still use Cross tab queries?

I tried to copy the sql code and apply it to sql but it complains that transform is not applicable in sql.

Does any one know how to create a cross tab in sql?

I would appreciate if some one can post a small example.

Thank you

Dwight

 

[cmmrfrds]

See these threads.

thread958-1113528
thread958-1113493

 

[dwight1]

Thank you