By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
454,330 Members | 1,862 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 454,330 IT Pros & Developers. It's quick & easy.

Fill Down in Access ?

P: n/a
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
Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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.
Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.