1218 0072 NOTE Blank Spaces Are Not Permitted Form

Instructions and help about 1218 0072 NOTE Blank Spaces Are Not Permitted

sometimes you can have fields that contain empty values these values are considered null a value of nothing you may need to fill in blank fields with some logical values that indicate a missing value filling in the null fields in your data set is as simple as running an update query for example in the products table in the discount field we have some null values on the create tab in the queries group click on query design add the table products add the field discount click on update in the query type group in the update to row enter 0 in the criteria row enter null access automatically adds ease click on run click on s to confirm the update open the table and you can see that the null values are replaced by zero note that there are two kinds of blank values null and empty string when filling in the blank values of a text field include the empty string as a criteria in your update query to ensure that you don't miss any fields for example description has null and empty values in the qu