fulfilling empty rows

[vojinb]

Hi,
I have column in table (integer type) where I have values like

1001
-blank-
-blank-
1002
-blank-
-blank-
1003

What I want to do is to fullfill blank rows in next manner:
between 1001 and 1002 all blank values to be 1001
between 1002 and 1003 all blank values to be 1002 and so on,
but query
"update table set field =1001 where field between 1001 and 1002" not working,it is same when I try with > and <

[AndreT]

If you have only one column in this table, you're doomed. In a spreadsheet, you can drag each number down to a specific cell, but Access is a relational db which applies every action to all records.

If you have an autonumber ID, or some kind of key for this table like:
(1, 1001)
(2, blank)
(3, blank)
(4, 1002)
(5, blank)
(6, blank)
(7, 1003), etc.
There is still hope.

Do you have anything to identify a row?

[vojinb]

Hi, i have already solved the problem with next code:

Dim rs As DAO.Recordset
Dim currentValue As Long

Set rs = CurrentDb.OpenRecordset("select * from tblData order by ID")

With rs

Do Until .EOF
If IsNull(!myInteger) Then
.Edit
!myInteger = currentValue
.Update
Else
currentValue = !myInteger
End If
.MoveNext

Loop

End With

Set rs = Nothing

Thanks for help