DAO rs loop by date sort question

[TrollBro]

Hello

I want to use DAO to loop through a large file in ascending [date] field sort order, and for each record, evaluate the record's [amount] field. If the [amount] field is null, I want to append the dollar [amount] value from the prior (i.e. most recent prior date) field to the current record's null [amount] field. Thus if the value on June 5 is $1.25 and the value on June 6 is null, I want to populate the June 6th dollar field with $1.25.

How do I cycle through the records assuring the sort in ascending date order using DAO?

Any help would be very much appreciated.

Thanks!

 

[PHV]

Simply add an ORDER BY clause in the SQL code.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886