filling up blanks

B

Brian

I've imported a txt list into Access which has some rows that look
like:

0000 0100 CH Saze National Msr 1 M CH 4460b 4750x 4800q 5945b

6030b 6125s 7275b 7290b

9500s 9630q 9675b 9845b
0025 0130 SG Niskale V BNN 11720s 11750s
11760s 11925L

11960b 12045b 13610n

13700L 15550b

Now I'm wondering whether would be possible to automatically update the
rows which has some blank fields with its appropriate information
(that's the same stuff as in the first and fourth row).

Of course, most of the rows has all the fields properly filled up, it's
just too cumbersome and time consuming to fill the blanks by hand.

Thank you in advance for your aid!
 
D

Daz

would a simple update query not do the job?

Search for the selected fields being null or "" and then update them to
whatever you need.

If you need Access to import the data and then automatically update it,
create a macro that imports and then runs the update query.
 
B

Brian

The data is separated into fields in a table which always will, either,
have all the fields or just the last one.

Despite an Update Query is the way to go, being as naive as I am, I
don't know how to do it.

In the following example:

AAA BBB CCC 123
DDD EEE FFF 456
579
333
GGG HHH III 789

In this case registers which have in the last field 579 and 333 are the
ones to be updated. What I need is to "write" DDD EEE FFF into the
three separate blank (null) fields on both registers.

A register having blank (null) fields will always need to be updated
with the same information as the preceeding one.

What expression I must write on the update query in order to perform
it?

Thank you in advance!
 
Top