Auto Fill blank (null) records

[David Canfield]

Hi,

I currently have a MS Access table that gives a field value when it occurs
for the first time but not subsequent occurrences - ie. the blank cells
underneath, in the subsequent rows/records are assumed to have the same value
as above.

In essence I'm looking for a macro/global way of finding all such blank
(Null) cells, and then using the function {Ctrl} + {' } where the cell I'm in
is blank.

Thanks for any assistance you can provide.

David

 

[Alex Dybenko]

you can try to make an update query, which updates null values to previous
not null value. you can use a subquery (or dfirst function) to get such
values.