Filling in blank fields with a parameter

[eb]

I have a problem. This is probably very simple, but I can't seem to wrap my
head around it.

I have a table with multiple columns.

Here is an example:

Column A Column B Column C
Cats whiskers
Cats sammy
Cats fluffy
Cats moppsie
Dogs rover
Dogs lassie
Dogs prince

Column C is an empty field

What can I do to add one parameter in the query for Column C so that the
table looks like this:

Column A Column B Column C
Cats whiskers furry
Cats sammy furry
Cats fluffy furry
Cats moppsie furry
Dogs rover furry
Dogs lassie furry
Dogs prince furry

I hope I'm not to vague. Thanks in advance!

EB

 

[John W. Vinson]

I have a problem. This is probably very simple, but I can't seem to wrap my
head around it.

I have a table with multiple columns.

Here is an example:

Column A Column B Column C
Cats whiskers
Cats sammy
Cats fluffy
Cats moppsie
Dogs rover
Dogs lassie
Dogs prince

Column C is an empty field

What can I do to add one parameter in the query for Column C so that the
table looks like this:

Column A Column B Column C
Cats whiskers furry
Cats sammy furry
Cats fluffy furry
Cats moppsie furry
Dogs rover furry
Dogs lassie furry
Dogs prince furry

I hope I'm not to vague. Thanks in advance!

Do you want to permanently update Column C to "furry", or just display "furry"
if Column C is null, or just display "furry" regardless of what's in Column C?
You say it's empty - but are you sure it's empty for all records?

 

[EB]

Do you want to permanently update Column C to "furry", or just display
"furry"
if Column C is null, or just display "furry" regardless of what's in
Column C?
You say it's empty - but are you sure it's empty for all records?

Yeah, it's empty. This is just a temp record anyway. I'm importing a csv
speadsheet into this table and then wiping it clean afterwards. Whill this
work with a parameter? I tried using "fluffy" and it works fine. But,
whenever I use a parameter it doesn't update the records. any other ideas?

EB

 

[John W. Vinson]

Yeah, it's empty. This is just a temp record anyway. I'm importing a csv
speadsheet into this table and then wiping it clean afterwards. Whill this
work with a parameter? I tried using "fluffy" and it works fine. But,
whenever I use a parameter it doesn't update the records. any other ideas?

Sorry, I don't understand this. Where are you "using a parameter"? Please post
the SQL of your query.

You can do this in two steps - first an Import, and then run an Update Query
to update the field; but I'm not sure that's what you're asking!