Auto Fill blank (null) records

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
Back
Top