>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