General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>My dear Professor
>
>Your codes work fine.
>Is it possible to show output as follows
>
>code -----------May-----------June
>1111 ----------300-----------600
>1112 ----------200--------------0
>1113 ------------ 0------------400
>
>The month names should appear in vertical with data
>
While you can do it as Hilmar suggests, this kind of problem can be solved using the cross-tab generator that comes with VFP, VFPXTAB.PRG in the home directory. The advantage of using the cross-tab generator is that it can solve the general problem, so that you don't need all those IIF()'s in your query.
Tamar
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only