Replicate missing data into null entries

[octocom]

Hi there

I have some a little programing in microsoft access vb and so I am here asking for advice.

I need to copy a data value from one field down the list of null entries till it reaches the next value and then use that an so on in a loop.

E.G
[Area Code]
199a
null
null
null
null
132f
null
null
null

Regards

Luke

 

[PHV]

How is the list ordered (sorted) ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886