>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