Hi everyone, this is my first post in AccessForums.net and seeking some advice from the experts as I'm beginning to learn Access.
I have a database in Access where I have blank spaces (in red):
I want to update these blanks with the label 'Others' as shown in the green table. I am able to do this through separate Update Queries as the example below:
Is there a way I could do it all Display/Proc/OS/RAM/HDD in the same query to keep my DB query clean as possible? This is the SQL code made by the Access wizard for Display:
UPDATE [Features] SET [Features].[Display] = "Others"
WHERE ((([Features].[Display]) Is Null));
Thank you all in advance,
Dude