Fill Down in Access ?

[Stephen H]

I'm a newbie to writing and running code in MS Access so the more
detail the better for me when answering. Thanks.
My Problem ( Or Challange , I should say ) is that I import a csv file
into an access table called 'booked' ; one of these fields is called
"job".
Now when this import happens there are a lot of records that are
blank.
I need to populate these fields with the previous records' value.

ie. ( I am substituting in a "-" for a blank here )

Job
045122
-
045211
-
-
054155
-
-
Needs to be

Job
045122
045122
045211
045211
045211
054155
054155
054155

Can anyone show me the code I should use for this ?
Thanks in advance

Steve

[rkc]

Stephen H wrote:

I'm a newbie to writing and running code in MS Access so the more
detail the better for me when answering. Thanks.
My Problem ( Or Challange , I should say ) is that I import a csv file
into an access table called 'booked' ; one of these fields is called
"job".
Now when this import happens there are a lot of records that are
blank.
I need to populate these fields with the previous records' value.

Same goes when asking a question. The more detail the better.
How are you doing the import?
Is there any relation between the record that is not blank and
the following records that are?
Maybe mention the rest of the fields in the booked table.

There may be someone who can tell you how to create a query that
will fill in the blanks after import.

You may need to write your own import code.