I was wondering how to fill a column in a table (with records already present) if the value is null. I have tried setting a default value in the table, but that only works on new records, not existing ones. I also tried to query the table, so in result update the table, but that did not work either. Could someone give me some advice on that. Thanks.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Column Fill IF Value Null
- Thread starter Fletch12
- Start date
Most easily done using an update query. Create a select query, use the icon to convert it to an update query, put "Is Null" in the criteria grid for the field you want to amend and add the new value. Run the query, using the exclamation icon and Bob's your uncle!
- Status
Similar threads
- Locked
- Question
- Locked
- Question