Are you trying to SUM data from fields in two different tables? Please post a few more specifics, like which table
code1, code2, code3, REG, and
FY belong to, and what's the relation between the two tables.
>This returns the number 0.
>
>One of the FOR conditions involves data from a second table. I tried doing a SET RELATION command before doing the SUM command, but that returned the message "Cyclic relation". I must be missing something somewhere.
>
>To SUM what I'm trying to DO: Working in VFP3, I'm creating an Excel spreadsheet. The data sums up , by month, expenses for the fiscal year. I'm dropping this into Excel because 1) I thought that would be easier than fighting with the Report Writer, and 2) I thought I'd learn something new. So I've figured out how to open a new worksheet in Excel,drop labels into cells, and display it on the screen. What I still want to figure out is how to format my headings, and actually put data from my VFP tables into the spreadsheet in the appropriate cells. I have reports created, through the Report Writer, that will do what I want for each month. Now I just need to SUM for the year, or for the Year to Date.
>
>Thanks.
>
>Kim
Rick Borup, MCSD
recursion (rE-kur'-shun) n.
see recursion.