Sophie has attended:
Access Introduction course
Access Intermediate course
Excel Advanced course
How do I fill an entire column with a value?
For example if in a table my column heading is 'Country' and I want all cells that are blank to be filled with United Kingdom how would I do this? Or for example if some of the cells in another column = 'uk' then how could I get all of the cells in the country column to be filled with 'United Kingdom' if the specific cell in the same row had the value UK?
I look forward to your response.
Kind regards,
Sophie Lloyd
RE: How do I fill an entire column with a value?
Dear Sophie
Thank you for attending Access Intermediate course!! I hope you enjoyed the course and benefited from it.
This seems to be an interesting question. There are few solutions to your query.
If you want only a new record to always display same data then you can go to the design view of that table and enter the value in the Default value box in the field properties section. Please bear in mind that it will not affect the current data in the existing field (Column).
I think the following solution is much more appropriate if you already have many records in a field (Column) and just want to update the entire field with the same data.
TO UPDATE ONE FIELD ONLY THAT IS BLANK:
You must have covered update query in your Intermediate Access course.
Please follow these steps:
1. Create a new query and choose the table from the