Try doing a
COUNT FOR table1.reported#.T. AND MONTH(table1.endingper)=m.month AND YEAR(table1.endingper)=m.year
and see if it is zero.
>Hi all:
>
>I'm trying to create a report that needs to be run for monthly data. However, the PREVIEW screen just flickers, then returns to the form that I have set up to specify the time frame for the report. Suggestions?
>SELECT table1
>SELECT table2
>SET ORDER TO myorder
>REPORT FORM rpt_summ PREVIEW FOR table1.reported#.T. AND MONTH(table1.endingper)=m.month AND YEAR(table1.endingper)=m.year
>
>I've also tried:
>REPORT FORM rpt_summ PREVIEW FOR table1.reported#.T. AND table1.endingper>=m.start AND table1.endingper<=m.finish
>
>I get the same results. If I try to send this report to the printer, and add the prompt, I get the printer prompt, but no report.
>
>Thanks.
>
>Kim
Rick Borup, MCSD
recursion (rE-kur'-shun) n.
see recursion.