I did a similar report, to deal with it, the system, through a user action saves the balance to a given date,they can do this operation as many times as they want, and they can only get a starting balance from the dates the did this ,they usually do it monthly, works for them.

But now that I think about it you could get your starting balance from a parameterized view, with the user given date as the top limit, the view must sum up the data up to the specified date to get the balance.

In the report you would have the view as parent to the LOG file, and then just add or substract using iif(...), HTH


>I need to create a report based off information in a file I call LOG. This is an accumlative file being that it has data (mostly amounts) that start with an initial starting balance record and progress.
>
>I need to have the user select the starting and ending dates for the report. The report needs to read all records PRIOR to the starting date to get a starting balance and only print records from the starting date through the ending date.
>
>The balances depend on the various records record type... some add to certain fields, some subtract, some just printout.
>
>The concept seems relatively straight forward except I only have written reports that list ALL the data in the file and doesn't do the selected printing, selected reading and mathematics based on a field type.
>
>How do you accomplish something like this with the report writer? Suggestions?