>I wrote a program to report on 4 months of data, I use genxtab to create the tabulate the data and then run a report. It worked great until someone decided to run the report before all the data has been entered. The last month is august and hasn't happened yet. Now the genxtab program leaves out that month since it doesn't exist, and my final SQL statement to combine all the data before running the report bombs. This is in FPW26 by the way. Is there a way to use a union to select 0 for the months without data? or some other solution that escapes me? Thanks,
>
>Shane
You couldn't just rerun the query that selects the data genxtab uses? I do not understand why the problem would be permanent since genxtab sends the output to a table name specified by a passed parameter.
You could try something like the following to get a list of unique months that have data --
select year(DateField) as nYear, month(DateField) as nMonth from sometable group by nYear, nMonth
Other than that, I am confused as to what exactly the problem is or why it has become a problem.
Mark McCasland
Midlothian, TX USA