(Reply) old data/archive records

[Bob Stockler]

On Mon, May 10, 2004 at 03:49:06PM -0400, Butch Ammon wrote:
| 
| No, we're just using standard everyday automatic indexes.  When
| running a cost  report from "oldorder" using Request Output, it
| still reads the 82,000 some odd  records.  It's okay and runs
| great, but, well, you know how some people can be. 
| They want things NOW.

If the data in "oldorder" isn't modified from time to time,
use the "lookup -" sort-selection table to run your report
on each year's records and write the results to a "results"
file - each year's results being written to a record keyed
by the year number.

Then, when you want a report on the whole file, use the "lookup -"
technique to just read the current year's records in "oldorder",
and get the previous years' results by lookups to the "results"
file, then put it all together for your report.

If you're unclear about the "lookup -" technique I'll be happy
to send you a table that illustrates it very clearly.

Bob

-- 
Bob Stockler - bob at trebor.iglou.com
Author: MENU EDIT II - The BEST Creator/Editor/Manager for filePro User Menus.
Fully functional (time-limited) demos available by email request (specify OS).