Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
How to rate a table? (maybe crosstab)
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00405792
Message ID:
00405800
Vues:
20
Yes crosstab is a Solution. I don't know if you knows how to do it, but just in case I'm sending the code:

Selec year,cat from your table;
group by year,cat;
order by year cat;
into cursor c_cursor

DO {_GENXTAB} WITH "Query",.t.,.t.,.t.,,,,.t.,0,.t.
Browse nomodify


Also if you use Office 2000 you can use The PivotTable Ocx.
"Anyone who has never made a mistake has never tried anything new." A.E
"The important thing is not to stop questioning. Curiosity has its own reason for existing." A.E
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform