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

filling up blank fields

P: n/a
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!

Nov 29 '05 #1
Share this Question
Share on Google+
4 Replies


P: n/a
I can't tell if the data is just a string of text or whether it is separated
into fields in a table, but I'll assume the latter. In your example, it
looks like you either have all the fields or just the last field. Is this
always the case? If it is, then you can run an update query. Select field1
and field4 (or whatever the last field is called) in the query builder.
Under field4, set the criteria to "is null" (no quotes) and set the update
to box to [field1] (with brackets). Under field1, set the "update to" box
to "null", (no quotes).

"Sommerfield" <co*********@yahoo.com> wrote in message
news:11**********************@g49g2000cwa.googlegr oups.com...
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!

Nov 29 '05 #2

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

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!

Nov 29 '05 #3

P: n/a
I'm wondering whether it is actually possible to do so.

Dec 2 '05 #4

P: n/a
Sommerfield wrote:
I'm wondering whether it is actually possible to do so.


It's possible. I just didn't think it was right to tell you how to do
it.

See:

http://groups.google.com/group/comp....ff3f71a41b982a

If you can, change your input forms so that this doesn't happen
anymore.

James A. Fortune

Dec 2 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.