Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to rate a table? (maybe crosstab)
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00405792
Message ID:
00405800
Views:
19
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
Previous
Reply
Map
View

Click here to load this message in the networking platform