Blank Field

[Guest]

Could someone show me how to replace a blank field in a table.

Thanks

 

[Baz]

Replace with what?

 

[Guest]

Perhaps it is better to say that I want to fill up the blank field with
something using
"Replace" function.

Thanks

 

[Guest]

Replace with what?



Perhaps it would be better to say that I want to fill up the blank field with something using the Repalce function

 

[Rick Brandt]

Perhaps it is better to say that I want to fill up the blank field
with something using
"Replace" function.

The Replace function is for replacing a "piece" of a string with some other
piece. To fill an empty field with a value all you need is a straight update
query.

UPDATE TableName
SET FieldName = "SomeValue"
WHERE FieldName Is Null

 

[Douglas J. Steele]

UPDATE MyTable SET MyField = Replace([MyField], " ", "_")

will replace all blanks in the field MyField with underscores, whereas

UPDATE MyTable SET MyField = Replace([MyField], " ", "")

will simply remove all the blanks from the field.

To do this through the graphical query builder, create an Update query as
normal, and put

Replace([MyFIeld], " ", "_")

in the "Update To:" row in the MyField column.