>>I have been asked to do something I know is doable here I go...
>>
>>I need to be able to design a report or form/report that has a date criteria ie Records from Date to Date where date is filled in by the end user to get totals for x reports.
>>
>>If anyone has any ideas or articles on a simple date interface type thing????
>>
>>Let me know
>>
>>Thanks,
>>
>>Fred W.
>
>Fred,
>
>You need to design a Report Selection criteria form which would run your report.
>
>Create a form, put two textboxes on it txtFrom and txtTo and a command button cmdRunReport (and one more for Close, if needed).
>
>In the Init of the form put
>
>thisform.txtTo.value = date()
>thisform.txtFrom.value = gomonth(date(),-1) && One month difference
>
>The button will run form's method RunReport
>
>In this method you select data for your report using SELECT-SQL statement and the values from your texboxes and then run the report using REPORT FORM command and the cursor with the data.
>
>You can access local variables in your report, so you can add selection criteria to the header of your report.
>
>Or simply buy Stonefield Query that can do all your reports for you.
Wow thanks and I will probably look at stonefield or ?? down the road, it is kind of cool stumbling slowly and learning too.

Again Thank You.

Fred W.