>I have a table that looks like this:
>
>
><b>artnr date</b>
>2 1999-04-01
>2 1999-05-01
>2 1999-05-01
>3 1999-04-01
>
>And I want to have make something to get something like this
>
><b>artnr Jan Feb Mar Apr May ... Dec</b>
>2 0 0 0 1 2
>3 0 0 0 1 0
>
>
>Anyone who can give some clues how to write the SQL-command? I could problably write some code to fix it, but there ought to be some cunning SQL-phrase that would take care of it for me.
>
>/Pierre Unge, Sweden
Look at VPFXTAB.PRG that ships with VFP. IT would be easier to run an SQL SELECT to get the data you want, then run it through VFPXTAB to get the final result.
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer