[AccessD] replace in blank (is Null) Field

Pedro,

Use an Update Query

UPDATE YourTable SET YourTable.YourField = "The Updated Value"
WHERE (((YourTable.YourField) Is Null));

Bryan Carbonnell
bryan_carbonnell at cbc.ca

>>> pedro at plex.nl 29-Apr-04 12:15:08 PM >>>
Hello Group,

i want to use the replace in fields that contain no data (is Null). The
help function gives as solution to use find and then replace manually.
Is there another option?


Pedro Janssen