>
>I have a form, which I use as a navigator, containing all the tables/views I need. On this form I have a button which calls a form used to collect the dates which I need to run reports on. I have this code in the click event of the button on the navigator form which collects the dates and sends them back to a wait window.
>
>DO FORM TestParam
>
>WAIT WINDOW "BEG: " + DTOC(gaDateRange[1]) + " End:" + DTOC(gaDateRange[2]);
>+ ' Employee: ' + gaDateRange[3]
>
>RELEASE gaDateRange
>
>How can I modify this code so that I can select only appointments for these dates and send them to a report. I guess in other words, I want these parameters sent to the report, but am unsure of how to define / call them. Another way of putting it is I need to take the dates from the wait window and pass them to a report.
Usually I use a SELECT - SQL statements (or several) to prepare the report.
In this case, you would need something like this:
select * from MyTable;
where DateField between gaDateRange(1) and gaDateRange(2);
into cursor TempResult
HTH, Hilmar.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)