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
--Shane