How to use beginning and ending dates in a dialog to produce a report 1

[keysol]

How do I create a report using beginning and ending dates inputed by the user in a dialog box to set the period.
For example to print a report containing sales realised from the 1st of january 2001 to the 31st of January 2001.

I assume my dialog box must contain 2 date fields set as variable type. I also assume I must write a macro that will pass this information to process the report. But I can't figure out where and how I must do this.

 

[suesloan]

The key is in setting up a Find using the variable fields. To do this, put some valid dates into the two fields (valid means that using them in your Find will result in at least one record being found. Then on a form or worksheet view based on your target database, enter the following into a text field while in Find Mode:

If(yourdatefieldname >= varstartdate and yourdatefieldname <= varenddate)

Press Enter or click OK to do the Find. Now type the name you want to use for this Find over the &quot;Current Find/Sort&quot; text in the field box on the Action Bar. You now have a named Find you can use in a Find command in your macro!

Sue Sloan

http://www.xpertss.com

 

[keysol]

Thanks Sue for a simple solution to my problem. But this brings me to a bigger problem! Finding useful reading on the subject of Lotus Approach. I've scoured many book stores as well as the WEB without much success. There is lots to read on the subject of MS Access but when it comes to Approach, the best I've gotten is a book that basically overviews the SmartSuite. Would you have any help in this departement?

Again, thanks. I'll probably be back.

Gérald

 

[suesloan]

Actually Lotus published a book on the basics of Approach as an Adobe reader file, and I have put a copy of it in the &quot;Free Downloads&quot; on XpertSS.com for the convenience of Approach users.

And if you find a book on any version of Approach from 96 up, the basics are pretty much unchanged. None of the books will cover LotusScript - that is a &quot;self-study&quot; project!

Sue Sloan