>I have a table with null values in fields here and there. I would like a query that fills these in with values from the most recent record with something in that field. For example, if I have:
>
>field1 field2 field3
>
>3 5 6
>5 6
>7 2
> 9
>2 1 8
>3 2
>
>I want:
>
>field1 field2 field3
>
>3 5 6
>5 6 6
>7 6 2
>7 6 9
>2 1 8
>3 2 8
>
>
>Thank you.
Bret, instead of a query, try a method/prg with scan..endscan. That way you can scatter the values of record 1, then in the next loop check record 2 for blanks and fill them in etc.
HTH
Barbara