>Hilmar,
>
>This only solves part of my problem. What I need is a matrix listing the last five months(in first column), the second column listing the total DCN's for that month, the third column total EO's for that month. I should have hae five rows and three columns.

Try something along these lines:

SELECT month, code, COUNT(*) ;
FROM YourTable ;
GROUP BY 1, 2 ;
INTO CURSOR Result

Obviously, you'll have to substitute your actual field info, and add a WHERE clause to filter the results for the last five months.

Tamar